To add What Sean is saying; changes are often not just DDL schema changes; when you add a new table, you may have added new rows in that new table...

don't you just need to assign a new default database to the login in question?

assigning it master as the default is what i typically do.

ALTER LOGIN login_name WITH DEFAULT_DATABASE =...

also watch for those fields that are missing the dash:

SELECT

CASE

WHEN CHARINDEX('-', CID) >= 0

THEN LEFT(CID, CHARINDEX('-', CID) - 1)

...

Id say that a server side trace has an incedibly small footprint because its not capturing much; plus you get better tracing than watxhing a dmv and infering a logoff.

Test...

the advantage of the procedure is if i decide i want one running all the time, i can set the procedure to execute on server startup, so the trace gets...

I do.

this script adds a stored procedure, which i assume you would put in master:

linky for sp_AddMyLogonTrace.txt

After running the script to create the procedure, if you run

EXEC sp_AddMyLogonTrace

it will...

while not exactly a hosted environment, we provide our testers with he ability to restore their own specific database from a web page;

the page lets them select the path to...

for me , RBS needs the acronym spelled out, please;

is that Remote Backup Software? Remote Buying System? Royal Bank of Scotland? Really Bad Service? some software package?

i think the cursor is missing the FETCH that is supposed to be inside the cursor, so it knows to get the next record.

as it is now, it is processing...

Reverse the order of the tables isnmy recommendation.

Select from sys.tables where not exists in then dmv isnthe way ive done it.

i think raising an error of level 20 disconnects the connection, so no further processing after the error would occur regardless of terminators; would that help instead?

can you go back to the source and get the same data in another format?

AFAIK, there's no way to import from a PDF; you might be able to grab teh...

yogi123 (8/2/2012)

---

Lowell (8/2/2012)

---

the reindexing can be a huge operation; 1.5x the size of the indexes being rebuilt, as i seem to remember it. so the reindexing of a bunch...

the reindexing can be a huge operation; 1.5x the size of the indexes being rebuilt, as i seem to remember it. so the reindexing of a bunch of indexes...

a post here by Gail Shaw(Gilamonster) says it might be the log has filled up on the database:

http://www.sqlteam.com/forums/topic.asp?topic_id=132921