Viewing 15 posts - 7,261 through 7,275 (of 9,244 total)
gemisigo (2/22/2011)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 22, 2011 at 2:56 pm
Scripting jobs is way too much hassle. In this order
Run server side trace
Identify culprit
Slap heads
😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 22, 2011 at 2:30 pm
gemisigo (2/21/2011)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 22, 2011 at 8:10 am
i would use a csvde query to dump to CSV file and then import this into a sql server table, bit convoluted but in my opinion much better all round
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 20, 2011 at 8:37 am
Leo.Miller (2/14/2011)
Can the file be modified to allow you to see multiple package stores on disk?Cheers
Leo
The following link quotes
Books On Line
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 15, 2011 at 7:17 am
this thread is a year old!!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 15, 2011 at 6:59 am
in synchronous mode if the transaction does not commit on the mirror it is not committed on the principal. This is the idea of synchronous mode, the principal waits until...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 13, 2011 at 12:20 pm
Another Reason: sql 2005 has a new system db MSSQLSystemresource db which has system info,where as in sql 2000 master has all system info.
is this also a reason.
😉 answered your...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 13, 2011 at 11:48 am
are you deleting all the data in the table or just image columns, truncate gets around this issue but does remove all data. This article may also explain a little...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 13, 2011 at 10:59 am
Derrick Smith (1/31/2011)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 4, 2011 at 9:53 am
probably be something along the lines of
C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log
the setup failure will display the log file name and path!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 31, 2011 at 2:37 pm
iamsam.sandeep (1/31/2011)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 31, 2011 at 2:12 pm
has someone taken a full backup of this database by any chance?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 31, 2011 at 2:10 pm
copy the job from another server and don't forget to change the computer name in the job step 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 31, 2011 at 2:07 pm
pipe the output of this into a table
sqlcmd -Lc
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 31, 2011 at 2:05 pm
Viewing 15 posts - 7,261 through 7,275 (of 9,244 total)