In 2000 that might work but in 2005 you can't alter the system tables anymore.

Like I said you could go the DMO route but probably just scripting the whole thing...

Basically the same method. Script it, then search for the DBNames and change them, or since you are putting it all in the same place you can basically just...

Ok, I'm not Jeff but I'm gonna take a shot at this anyway 🙂

First the question

The /7*7 gives you a different number because the 7's are...

Personally I would think you are better off keeping them in seperate databases unless there is some logical relationship between them. However if you do want to merge them...

Actually as long as you use an ALTER instead of a DROP and CREATE you should avoid the dependency problem.

You might be able to write a SQL DMO...

sql_er (11/12/2007)

---

I don't think what I am about to suggest is the best way to go, but it satisfies your non-manual constraint:

1. Script out all views, together with exec privileges...

Actually I have seen this done one way (with an active X script) and done it myself another way (admitedly it was by being a bit tricky and using 2...

I set up a nice little system of traces on my servers and have noticed at best a negligable performance hit.

As an example I have one trace that logs logins,...

Unfortunatlly no. They want the whole thing moved. I have the system databases on D already (I did the instance on D but didn't realize that I had...

Great suggestion 🙂

Ok here is the next question. I have completly uninstalled my server (I have 2 I'm working on) and I'm doing the re-install. I have gone...

I don't suppose you know any way I can keep all the work I put into it? For example all of the logins, linked servers, and expecially the DTS...

You know I used almost that exact question as a tech test for a DBA job one time.

I did the following test and it worked just fine

create table test (id int not null identity (1,1), val1 char(1))

insert into test values ('A')

insert into test values ('B')

insert into test...

Is it possible there are network errors?

A couple of tests you could run:

Once someone who used to be able to log in can no longer log in try opening a...

To the best of my knowledge you can't move columns around. You can only add them to the end of the table. So what you are going to...