Forum Replies Created
Viewing 15 posts - 1,606 through 1,620 (of 1,790 total)
-
RE: Variables using Select
My bad! That is what I get for typing before going to a meeting. Sorry for misleading you!
David
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
-
RE: Variables using Select
Use the substring function i.e. substring(columnname, 12, 16) first number indicates starting position and second number indicates stop position. BOL has a really good example there as well.
Hope this...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
-
RE: SP2 with hot fixes
You should see a 8.00.532 (or something greater with the hot fixes) for the version information that comes out with the select @@version.
I am assuming that this is for SQL...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
-
RE: xp_sendmail vs. xp_send_mail
Nor I on a 7.0 box. Never seen it before so, I would stick with the known MS xp_sendmail.
David
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
-
RE: Bulk Insert Task Failure
Make sure you can open the path in command line such as a DOS window or from the run line. If there are any spaces in the path it will...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
-
RE: Multiple Monitors
Very cool Steve! Did not know you could do this and the wheels are already turning to see how I can swing this here. Thanks!
David
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
-
RE: sysjobhistory run_duration
From SQL Server 2000 System Table Map (download from MS - search on systbl.chm)
"Elapsed time in the execution of the job or step in HHMMSS format."
Hope this helps.
David
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
-
RE: Using an update trigger to send an email
I wouldn't do the mail in a trigger but rather a stored procedure and then create a job to run the procedure every 5 minutes or so. That way when...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
-
RE: Restoring database to a new server
quote:
Can we use the detach/attach method going from SQL7 to SQL2K ? Would the difference in system tables cause a problem...David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
-
RE: Restored db still shows as "Loading"
Depends on the scenario. Some instances I will keep multiple days worth of files on disk other times I will overwrite each night. Some I will copy to other servers...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
-
RE: Restored db still shows as "Loading"
My post wasn't too clear when it came to the native SQL backups. I prefer them over third party for a myriad of reasons, your problem being one of them....
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
-
RE: Restored db still shows as "Loading"
So when you do a sp_who2 is there any connections open to the database in question? If so, close that connection then do the detach / attach. If that still...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
-
RE: Moving LogFile from one disk to another
Jeff,
This is a way out there guess but could you try attaching the database again using the single file method, backing up the database and the log and then doing...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
-
RE: Moving LogFile from one disk to another
And the sp_attach with new paths specified is not working with the new log file either?
David
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
-
RE: Restored db still shows as "Loading"
Let me guess, Veritas restore? If the Restore utility is not native SQL and has the restore job showing completed, you should be able to detach and reattach the database...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
Viewing 15 posts - 1,606 through 1,620 (of 1,790 total)