Viewing 15 posts - 151 through 165 (of 177 total)
Run the following and see what are there:
USE YOURDATABASE
SELECT object_name([object_id]) AS Objects_IN_Filegroup
FROM sys.indexes
WHERE data_space_id=104
January 26, 2009 at 11:41 am
My local drive (H drive) is full.
Could you identify what are making the drive full?
Is it becuase of your DATA files? or Your Transactional Log file (.LDF) is too big?
Do...
January 26, 2009 at 9:52 am
Try GUI:
Go to SSMS, Right Click the DB, Properties,
=> FILES==> see which file is under your filegroup;
=> Filegroups=> You can remove the filegroup from here.
January 26, 2009 at 9:00 am
search for DDL TRIGGER in BOL or this Website....or Google.
January 21, 2009 at 6:47 pm
Does the SQLAGENT Service account have WRITE permission on that share?
January 21, 2009 at 6:27 pm
Did you actually try that by calling a second job from the first or did you just execute the query after executing a job?
Calling a second job (auditing...
January 21, 2009 at 1:30 pm
Hi, You can add one more step as the last step in your Job. The step will call Another another job (your auditing job).
In your auditing job, u can use...
January 21, 2009 at 12:37 pm
Type "SQLWB" in Start-->RUN, and see what you got.
January 20, 2009 at 1:32 pm
Yes, it will.
The job is scheduled to run every 30 minutes (u can modify it to run as frequently as you want by changing the 30 in the WHERE clause)....
January 20, 2009 at 12:07 pm
The following is a job script i created to monitor job failures. You can modify it by replacing the email address.
USE [msdb]
GO
/****** Object: Job [Job Failure alert] ...
January 19, 2009 at 11:58 am
IsNull Took 13813 ms
Coalesce Took 14233 ms
on my laptop..
January 16, 2009 at 3:24 pm
Sorry for the incorrect answer above.
Yes, noeld is correct. It can be done to logshipping SQL 2005 DB to a SQL 2008 Server.
Connect to the SQL2005 instance within your...
January 16, 2009 at 3:13 pm
I tried on my laptop where both SQL 2005 and SQL 2008 Standard Edition are installed. And found the following:
--If set the 2005 instnace as primary, it won't let me...
January 16, 2009 at 2:16 pm
That's very cool! Matt. Didn't notice the report there until today. Thanks!
January 16, 2009 at 8:37 am
DBCC INPUTBUFFER(spid) will give you a hint what that spid is running. From there, you may find a clue.
January 16, 2009 at 8:21 am
Viewing 15 posts - 151 through 165 (of 177 total)