Viewing 15 posts - 376 through 390 (of 1,138 total)
silly question i know, but is the job enabled and is the schedule for that job enabled as well
October 7, 2009 at 7:24 am
edvaldocastro (10/7/2009)
The DBA from the company where I worked has been dismissed and from now on, I'm the new one. The AD login of him, was already disabled and...
October 7, 2009 at 7:20 am
I knew I could rely on someone else to post a query, you might want to restrict it though, as I do believe the op wanted it purely for the...
October 7, 2009 at 5:54 am
Jpotucek (10/7/2009)
October 7, 2009 at 5:50 am
Vishal Singh (10/7/2009)
SELECT count(1) FROM sysusersUse only as applicable.
that isnt right, that count includes database roles as well. if you want to include public, dbo, guest and INFORMATION_SCHEMA as well.
you...
October 7, 2009 at 5:43 am
is this a duplicate post, swear blind I answered it else where.
it is the report data option on the bottom of the view menu.
October 7, 2009 at 5:28 am
okiftequar (10/7/2009)
That is on this date and time.Date10/5/2009 1:56:25 PM
this db backup size is around 4532096kb.
If I am reading that right, that is 4.3 GB in size and you are...
October 7, 2009 at 5:24 am
Anchelin (10/7/2009)
Will you be able to guide me in the right direction, where I'll be able to find this information?
Or should I ask the person that developed the SSIS...
October 7, 2009 at 5:21 am
You can query the default trace, but I am interested to see what ideas others have.
October 7, 2009 at 5:11 am
Sounds like their is an issue regarding that connection, what is the type of connection, and does that destination exist and what permissions are needed to access that connection.
October 7, 2009 at 4:59 am
You wouldnt be thinking of the report data option, which is the last option on the view menu.
October 7, 2009 at 4:54 am
if you can run this ok using a script but not as a scheduled job. You have said that the sql agent is running under the 'NT AUTHORITY\SYSTEM' login
run your...
October 7, 2009 at 4:38 am
okiftequar (10/7/2009)
Weekly i m monitoring on my sql server 2005. Today i have found a error in my sql server error log file,
Error: 18210
'BackupMedium::ReportIoError: write failure on...
October 7, 2009 at 4:31 am
i can see what you are trying to achieve, you might be able to do it differently, can you script the table creation for wiptest and post it here. so...
October 7, 2009 at 3:51 am
Viewing 15 posts - 376 through 390 (of 1,138 total)