Hello, In response to a question I asked about a week ago I changed our database engine to only accept Windows Authentication instead of SQL Authentication. Because our code runs in a different user context then that of the database connection we need to specify the username and password information in order for us to connect to the dat...
I'm writing an application that is trying to bulk export data from a SQL Server database (with a given connection string) to a local file (in whatever format). Normally the sql server utility BCP.exe would be ideal, however, the bcp utility may not be available on the machine my app is running on. Also, bcp is not considered a redistri...
Was going to call this "Eval won't give me the Time of Day," but thought that too cute. I'm kind of having the opposite problem from the suggested questions I see for my title, so here goes: Visual Studio 2008 Pro, SQL Express 2008, Vista. Web Project, where I'm opening records from an Event Table with JOINed info from a Facilities tab...
Im using latest SVN 2.2 build compiled with VS 2008. When I build my VB classes using Sonic.exe any columns of type Date (Not Datetime) are generated as "System.String". Has anybody else found this problem and have a solution or is this a problem with Subsonic? ...
Hi, When I try to install SQL Server 2008 sp1 on my system, the installer runs and does the prerequisites check, every thing is ok except it says my machine has a pending reboot and won't continue until this is done. I Cold Reboot the machine,run the installer and the same message comes up. So I can't install the sp1 update. Any ideas ? ...
Hi, I have a table in a sql server 2008 database that contains bunch of records as well as a date column. The date is inserted automatically when a new entry to the table occurs. So, it contains the date of the record that has been created. I am trying to run a query that would return me the earliest date and the latest date in this t...
We are trying to have a transactional table that only takes new records inserted on a regular basis. This simple table requires us to continuously add new records to it over time. The volume of transactions into this table is expected to be quite high, and also there might be periodical batch imports of transactions (>1000) that may ta...
I'm setting up a SQL Server 2008 server on a production server, which way is the best to backup this data? Should I use replication and then backup that server? Should I just use a simple command-line script and export the data? Which replication method should i use? The server is going to be pretty loaded so I need an efficent method. ...
I'm looking at changing our Auditing process for our SQL Server 2005 databases and I came across Change Data Capture in SQL Server 2008. This looks like a good idea, and I'm tempted to try it, but before I do has anyone used it in a commercial environment and what are your thoughts? I noticed when I was reading about CDC in the MS hel...
I have the following SQL query: SELECT TOP 200 * FROM article WITH (nolock) WHERE CONTAINS(*,'"ram*" and "1*"') ORDER BY article_number I am getting no results returned within 10 minute. If I stop the query after a few minutes then it returns a few records. In article table there are 10,000 records. The full text catalog is on artic...
I've inherited a legacy system with lots (160+) of stored procedures. I'm looking for a way to create a diagram that would show which of the procedures are called by other procedures show which part of the C# code uses which stored procedures group the procedures by the parts of the system in which they are used Is there a tool that ...
Is it possible to change the default collation based on a column? i want to make 1 column case sensitive but all the others not ...
I am using "Object Explorer Details", and when I am on "Tables", I can select many columns, particularly "Create Date". However, when I am on "Views" or most any other part of the database, I only have a choice of columns "Name" and "Policy Health State". I really want to also have the "Create Date" (like I used to have in SQL Server 2...
I'm inserting a bunch of new rows into a table which is defined as follows: CREATE TABLE [sometable]( [id] [int] IDENTITY(1,1) NOT NULL, [someval] sometype NOT NULL ) using the following insert: insert into sometable select somefield as someval from othertable when I've finished, I'd like to know the IDs of all the newly in...
Exact duplicate: Advantages of MS SQL Server 2008 over MS SQL Server 2005? i am a sql developer and i use sql 2005. i want to now to pass to 2008 but i am a little affraid. can anyone gives me some advices about this. should i still continue using sql 2005 or is better pass all my projects to 2008 due to better performace? ...
We're having a problem with a merge replication. Our publisher runs SQL Server 2008, while our two subscribers run 2005. Our publisher is trying to send an ALTER TABLE Foo SET (LOCK_ESCALATION) command out to our subscribers. I think I remember reading that this command is new in SQL Server 2008, and if so, it makes sense that the com...
Hi, I previously had sql server 2005 express and uninstalled it.. I also uninstalled any vs related programs and installed visual web developer 2008 express edition with SP1. now that I am trying to install sql server 2008, I am seing error messages like no other and leave that alone without any suggestions.. the latest one which I coul...
I have a site that is taking around 20 seconds to load every page (no matter what it does) So i put in a /scripts/test.html that isn't part of a route and it still takes this long... no db hit nothing. I renamed the web.config to _web.config and it loads instantly, rename it back... back to around 20-30 second load times. Running the ...
What are some strategies for programatically setting up an email interface between a pop3 mailbox and an sql server database ? I'd like to be able to setup an account, say "[email protected]", and any email sent to that email address I'd like to senders email address, the subject and the body of the message inserted into a table (for ...
I am having problems with SQL Server dropping a connection after I have dropped and re-created a given database and the next time I try to execute a command against a new connection on that same database, I get: A transport-level error has occurred when sending the request to the server. (provider: Shared Memory Provider, error: 0 - ...