Viewing 15 posts - 46 through 60 (of 62 total)
Well I fixed it. Created a blank database which was given the ID of 7 and then dropped it. The job and sp run fine now. I can only think...
September 8, 2003 at 7:02 am
Verified that the ID 7 does NOT exist in sysdatabases.
I have scripts for the sp and the job and have recreated them more times than I care to remember but...
September 8, 2003 at 4:56 am
Have you recently restored this database? The loading state usually means that the database is waiting for more restores to happen e.g. transaction logs to be applied. It prevents people...
August 28, 2003 at 5:34 am
Instead of using LEN, See what values you get back from using
DATALENGTH(expression)
The LEN function ignores any trailing spaces - DATALEGTH will return the true length.
Should rule out field sizes on...
August 15, 2003 at 5:29 am
All your transaction logs must be applied on your secondary server in the same order they were done on the primary. For whatever reason the restore of the 4:05 log...
August 12, 2003 at 8:50 am
It's a non case sensitive install but thanks anyway.
It also crossed my mind that maybe the owner had been changed from dbo (how or why I don't know) but I...
August 7, 2003 at 7:37 am
Server: Msg 208, Level 16, State 1, Procedure TABLES, Line 4
Invalid object name 'sysobjects'.
Server: Msg 4413, Level 16, State 1, Line 1
Could not use view 'information_Schema.tables' because of previous binding...
August 7, 2003 at 2:15 am
Ah - that would explain it!
I'm trying to find when a database was last accessed and thought I could do it through that but obviously not. I've seen a few...
July 17, 2003 at 9:40 am
Profiler has traced the Admin account back to an Access application - thanks for that. Still looking for the others..........
July 1, 2003 at 10:25 am
They were all valid logins and not names you would normally guess. In saying that there's been 2 attempts to login with 'Admin' that have also failed. May have to...
July 1, 2003 at 3:59 am
That would appear to make sense.
However it appears on only one of my databases and that is Model - this database is certainly not offline.
I'll play around with taking db's...
May 21, 2003 at 8:42 am
Works perfectly - thanks very much!
May 15, 2003 at 1:36 am
I wasn't local admin on those particular servers - all sorted now.
Thanks
May 9, 2003 at 10:00 am
Thanks - we are running Remote Admin so we should be okay.
April 29, 2003 at 2:00 am
Viewing 15 posts - 46 through 60 (of 62 total)