Viewing 15 posts - 181 through 195 (of 219 total)
I guess you are totally heading in wrong direction, from your question it is my understanding that your data file or log file and the back file are on the...
June 24, 2003 at 9:40 am
Your question is so confusing.... If you want to see the server logging is working or not, change your server Audit level to All. You must re-start the server to...
June 24, 2003 at 9:02 am
Use the trace to capture the transactions and see is there any DELETE's ? If you are using SQL 7.0 use the follwing one
Exec xp_sqltrace Trace, @Fulltext = 1, @EventFilter...
June 19, 2003 at 2:45 pm
Go to Enterprise manager -> Data Transfermation services -> Select the package -> Open the package -> In the menu select Package/Save As -> Specify the Server name and the...
June 19, 2003 at 1:16 pm
We just found that SQL IP Address is not added to the dependencies list to the Physical disk where the systems files located. So what really happened is when we...
June 11, 2003 at 8:42 am
I restarted the Cluter service and it's its back.
http://support.microsoft.com/default.aspx?scid=kb;en-us;300183
June 10, 2003 at 4:15 pm
I am not sure either, May be that’s correct if the SQL Server IP Address fails, it moves the entire related services
Allen
I do see there is a message in the...
June 10, 2003 at 2:52 pm
Open the DTS Package in EM and Select Save As in the Package Menu. Specify the name, Location as SQL Server and the Server name.
June 6, 2003 at 2:25 pm
Any one in the Public role can create the DTS package. But the execution success depends on what they are going implement in it. If your DTS package creates objects...
June 6, 2003 at 2:20 pm
I will be very short-tempered with you in your interview? What do you mean by that? perhaps there is more than 50+ ways to optimize.
June 6, 2003 at 11:05 am
Check you linked server security is configured to allow both SQL and Windows.
Select the server go properties and click on the security tab
June 6, 2003 at 10:51 am
You will see some thing like
exec msdb..sp_drop_dtspackage
in the Data column of the output
June 6, 2003 at 10:00 am
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...
June 6, 2003 at 9:59 am
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...
June 6, 2003 at 9:49 am
MSsnapshot_history table contains the details you are looking for. You can see this in the Distribution database.
Select Agent_ID, runstatus, start_time from Mssnapshot_history where runstatus = 6
June 6, 2003 at 9:43 am
Viewing 15 posts - 181 through 195 (of 219 total)