Viewing 15 posts - 6,466 through 6,480 (of 9,715 total)
Could it be that the job cache hasn't been updated since right after you disabled things?
February 15, 2011 at 11:39 am
To add to what Nadrek just said, remember that just because the drive letter is different, doesn't mean the drive is different. Too many DBAs make the assumption that logical...
February 15, 2011 at 11:38 am
SQL Server does NOT track who created jobs, just the current owner of the jobs.
However, the work around is to create your own DDL trigger (if Create Job is one...
February 15, 2011 at 11:25 am
Ditto what GSquared said. Don't worry about the data in the table. Display is where that sort of things matter.
If you absolutely must tinker with the table, though, look into...
February 15, 2011 at 11:03 am
In addition to the breaking up of queries for better performance...
Temp tables give me the option of winnowing down my data results, and deleting duplicates as necessary, when working with...
February 15, 2011 at 10:59 am
Nothing in the logs happened right before these errors, except a few security audit failures in the Event Log. I've checked the SQL Server Log, SQL Agent Log, Application, Security...
February 15, 2011 at 10:56 am
What recovery model was your database set at? FULL, BULK LOGGED, or SIMPLE?
EDIT: Also, do you see the database in SSMS? Is it perhaps in Suspect mode instead of just...
February 15, 2011 at 10:45 am
I think embedded edition is even more crippled than the usual SQL Express. Which means certain options that Express has are not available unless you actually install Express.
See this link...
February 15, 2011 at 10:43 am
Oh, okay. I think I get what the issue is. Thank you for the second link.
I just don't understand why people would use varchar (or any string) to represent dates...
February 15, 2011 at 10:14 am
So, 4 eggs total or did you mistakenly enter the 2 eggs twice?
February 15, 2011 at 9:06 am
george sibbald (2/14/2011)
As this database has been upgraded from SQL2000 run DBCC CHECKDB with DATA_PURITY if you have not already done so (during next quite period yada yada :-))
Interesting. Either...
February 15, 2011 at 8:41 am
You're welcome. Let me know if you need anything else.
February 15, 2011 at 8:38 am
Actually, you can back up a single table. But there are caveats.
1) The table has to have a clustered index
2) The table has to be on its own file &...
February 15, 2011 at 8:02 am
I would follow the instructions. The .dll file is apparently important. Copy it over to the BINN directory before running the XP script. Then run the XP script.
Or did your...
February 15, 2011 at 7:56 am
Ray K (2/15/2011)
John Rowan (2/14/2011)
Bahamas (Thursday)Jealous!
Jelly
February 15, 2011 at 7:07 am
Viewing 15 posts - 6,466 through 6,480 (of 9,715 total)