Forum Replies Created
Viewing 11 posts - 1 through 11 (of 11 total)
-
RE: Job Doesn't Log Results
If I right click a job under the jobs folder and view history, I get nothing. If I right click the Jobs folder itself and select view history I...
-
RE: Using CASE in a delete statement
Thanks for your replies! Lynn, your query worked great.
-
RE: Using CASE in a delete statement
Lynn,
Yes, that is what I am trying to do.
Thanks
-
RE: Help with percentage calculation
Thanks for your help- I was able to get the info I needed.
-
RE: Backup & restore procedures for msdb
Sorry, my idea was for SQL 2000. I've been switching between forums and forgot which forum I was replying to. I apologize.
-
RE: Backup & restore procedures for msdb
I'm not sure if this is the proper way to do this but...I've run into this and after updating the originating_server column in the sysjobs table to the new server...
-
RE: using sort_in_tempdb when rebuilding indexes
Uh Jeff, did you have a bad day? Nowhere did I say I was on a production database, and nowhere did I say I was stuck between a rock and a...
-
RE: using sort_in_tempdb when rebuilding indexes
Thanks for pointing that out to me! Yes, we are using SQL2000. No wonder it wouldn't work
Unfortunately the indexes that are the most...
-
RE: @filename1 is not a parameter for procedure sp_attach_db??? what?
Uggh! Thanks. I had a feeling I was missing something dumb. You are absolutely right, the font I was using made it look alot like a one. And I didn't...
-
RE: Microsoft SQL Server: Maintenance Jobs failing strangely
Data type Range Storage bigint
-2^63 (-9,223,372,036,854,775,808) to 2^63-1 (9,223,372,036,854,775,807)
8 Bytes
int
-2^31 (-2,147,483,648) to 2^31-1 (2,147,483,647)
4 Bytes
smallint
-2^15 (-32,768) to 2^15-1 (32,767)
2 Bytes
tinyint
0 to 255
1...
-
RE: restoring
You need to restore your last full backup, then apply the last differential backup taken. You are talking about a database, right?
Viewing 11 posts - 1 through 11 (of 11 total)