Search is your friend...

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=112330

Andy

You can use EM to create a new Server registration using the machine name instead of local.

Drawback is that (local) connects EM to SQL Server via the memory network protocol...

Look again at the BCP format file in BOL, then look at the Fewer and More fields examples, notice that "" is valid for the Terminator column, in this situation...

You can use DTSRun.exe to execute on the MSDE server, and use the Windows Scheduler to schedule the jobs. MSDE does not support SQL Server Agent Jobs.

Andy

Database servers really "want" dedicated hardware, they are designed to use what you make available to them, so if you want to choke your database server to 80MB of memory,...

SQL Server can be installed on a Virtual server, however resist throwing a fit if need be, unless they are talking about "big iron" for the server.

Virtualization effectively divides the...

Your problem is the numeric(5,2), changing it to numeric(6,2) fixes the issue:

DECLARE @backed_up_page_count numeric(10,0)

        , @backed_up_page_count1 numeric(10,0)

SELECT @backed_up_page_count = ((50 * 1073741824.0) / 8192) -- 50GB

        , @backed_up_page_count1 = ((1...

Since you state that you are using Standard Edition, how much memory is available to the query?

From BOL: Is there enough memory available to execute the query in parallel?

If memory...

Try:

EXEC sp_msForEachTable 'EXEC sp_recompile ''?''' 

Andy

Actually Personal is SQL Server 2000 Standard with MSDE limitations and only requires a SQL Server 2000 CAL license.

Andy

Great article!

Why not change your PRINT statement to:

PRINT 'Select 1 - '+CONVERT(varchar(23),GETDATE(),121)

This will output:

Select 1 - 2006-07-19 21:24:09.230

Which should give you better timing diagnostics.

Andy

--SELECT * FROM CxCHon

DELETE FROM CxCHon

WHERE EXISTS (SELECT * FROM Historic WHERE Terc = CxCHon.Terc AND Val = CxCHon.Val)

Andy

I had to delete the DTS scheduled Jobs and reschedule the DTS Jobs to correct.

I documented the settings and rescheduled using EM as I only had 4 jobs to fix.

I was...

The account with "dbo" wins the db_Owner battle, generally.

When the other db_Owner or sysadmin creates the object, then it can be owned by <Other User>.<database object> instead of dbo.<database...

Use Data Sources (ODBC) Administrative Tools, Connection Pooling tab, and double click the driver in the list to turn on / off.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbc/htm/odbcsqlmanagedatasources.asp

More info:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbc/htm/odbcodbc_connection_pooling.asp

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbc/htm/odbcconnection_pooling_considerations.asp

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbc/htm/odbcodbc_connection_pooling.asp

http://www.sql-server-performance.com/sk_connection_pooling_myths.asp