Viewing 15 posts - 31 through 45 (of 90 total)
Assuming that TransactionDate is a DATETIME column, I'm not sure why you would need to format the parameter differently than what it is (i.e. mm/dd/yy hh:mi:ss.mmm).
Also be aware you may...
March 1, 2007 at 9:07 am
The script below was pulled from sp_changeobjectowner specifically for the error you are receiving. Substitute your owner.tablename where indicated. This should show you where the 'failure' is.
March 1, 2007 at 7:57 am
If you altered the varchar columns to char 'in situ' you might want to create a new table (Table4) with the columns in their final datatypes and copy the data from...
March 1, 2007 at 7:19 am
You might investigate Regular Expressions (called "wildcards" in BOL) for use in the WHERE. See "LIKE" & "Wildcard Characters" in BOL.
March 1, 2007 at 6:40 am
Hi Art,
Assuming that the OS is updated with the current Time Zone patches I would take a more proactive approach.
See: http://qa.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=265378#bm266370
You might also try: http://qa.sqlservercentral.com/forums/search.aspx?fid=8&query=daylight%20saving%20time
...if the above link doesn't work as...
February 13, 2007 at 12:20 pm
My preference is to perform each backup to a separate device with the device/filename in the following format:
ServerName_dbName_yyyymmddhhmmss_buType.sbk
...where
ServerName = the SQL Instance name
dbName = the database name
yyyymmddhhmmss = date/time
buType =...
February 12, 2007 at 10:34 am
Unless there is something specific to your timezone, I don't think anything needs to be done. There is an "Automatically Adjust for Daylight Saving" checkbox on the Time Zone tab...
November 30, 2006 at 5:18 am
That is probably not the only time! If you use sp_recompile, it, via the DBCC LockObjectSchema() function, will update both sysobjects.base_schema_version and sysobjects.schema_ver. It wouldn't surprise me that it also...
July 24, 2006 at 9:54 am
You may be able to use OPENROWSET() and substitute the DBCC command in for the <query> to directly insert into the 'master' table.
I did a process similar to yours and used an...
July 21, 2006 at 9:59 am
A little more info (e.g. DDL) would be helpful but I'll take a stab...
If the final result set is supposed to be DISTINCT'd then SELECT DISTINCT...
July 21, 2006 at 9:39 am
If the tape backup of the db was done via a SQL agent utilizing the SQL Server BACKUP mechanism and the tape software has the ability to restore the db...
July 21, 2006 at 7:36 am
A couple of questions to ask yourself...
Is the db size relatively static (9% unallocated is not that much if growth is anticipated)?
Are the db's composed of multiple filegroups (i.e. one...
July 21, 2006 at 6:51 am
I too wrote a slightly different version... Same binary concept, implemented slightly differently with a twist! It allows the specification of an increment or step value.
CREATE FUNCTION dbo.udf_genDateSequence ...
July 19, 2006 at 12:51 pm
Sergiy,
If you think you can't believe it you won't believe how unbelievable it is to me! I played with that thing until my eyes bled!! I guess I couldn't see...
June 27, 2006 at 7:29 am
Sergiy - very, very close but the thruDate [ ISNULL(Finish, MAX(Start)) ] in your SELECT is actually the start of the next FStateID/BStateID series instead of the end of the current...
June 26, 2006 at 10:42 am
Viewing 15 posts - 31 through 45 (of 90 total)