This is beacause it's undergoing a conversion. The default style is: hh:mm:ss (AM|PM) You can look under CAST AND CONVERT in Books Online for more information about the conversion. K. Brian Kelley http://www.truthsolutions.com/ Author: Start to Finish Guide to SQL Server Performance Monitoring http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
2003-06-06
1 reads
Could you do a quick Response.Write on your querystring and post the results? Are you absolutely positive that the string being passed to the Recordset.Open method is the same as the string you posted? If the query you posted functions correctly in query analyzer, then it is a problem with the string passed to the […]
2003-06-06
2 reads
From BOL. "In SQL Server 2000, DBCC CHECKDB holds a schema lock on the table to prevent meta data changes while the table is being checked, thus allowing DML statements but not any data definition language (DDL) statements on the tables being checked. This change provides greater flexibility as to when you can run DBCC […]
2003-06-06
1 reads
You will see some thing like exec msdb..sp_drop_dtspackage in the Data column of the output
2003-06-06
1 reads
You can capture the DTS package deletion in the Trace with the following statement. You will see the username, SPID, Time, and Application. Exec xp_sqltrace Trace, @Fulltext = 1, @EventFilter = 115 This works well in SQL 7.0, for 2K you need to register the sqltrace. dll on the server.
2003-06-06
2 reads
We have around 50+ 24/7 servers. We run DBCC 3 times a week. Yes I agree DBCC blocks the user process, especially when you rebuild the indexes. You need to run during the minimal activity on the server. We usually run early morning and some times midnight.
2003-06-06
here is the exact error message Server: Msg 3241, Level 16, State 37, Line 1 The media family on device 'e:\sqlserver\mssql\backup\attain_tlog_200306030900.TRN' is incorrectly formed. SQL Server cannot process this media family. Server: Msg 3013, Level 16, State 1, Line 1 RESTORE LOG is terminating abnormally. quote: Please ensure restoration of transaction logs is in correct […]
2003-06-06
2 reads
What I have found that works the best is to keep it as simple as possible. The next person that does our job may not understand what we have developed and would have trouble maintaining it. For this reason, I find that the best solution is generally the simple, straight forward solution. Sometimes this is […]
2003-06-06
OpenHack 4 was a competition sponsored by eWeek. They invited Microsoft and Oracle to lock down an application (Microsoft had to re-write it since it was in JSP, so they converted it to .NET) and then had an open invitation hack fest. The only break was on the Oracle side, but I believe it was […]
2003-06-06
Hi mlwang, quote: What is the different between SELECT and SET DECLARE @var varchar(100) SELECT @var = 'select * from tablename' SET @var = = 'select * from tablename' results are in both cases the same. However, MS recommends using SET for variable assigment Cheers, Frank
2003-06-06
1 reads
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers