Digs,

see if my reply at

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=168681

can help you. It was for the question that was about looping through tables. I replied there:

I would use sp_MSforeachtable undocumented stored procedure.

There...

It is a big deal not only when a DBA leaves. It is a deal every time you move a database from server to server. I have to use sp_changedbowner...

I would use sp_MSforeachtable undocumented stored procedure.

There is also a similar procedure sp_MSforeachdb see

http://www.sqlservercentral.com/columnists/achigrik/sql2000.asp

Yelena

Brian and Frank,

I just took a look at the table of Contents of C.J. Date's Introduction to Database Systems. It covers a big  variety of topics. But judging by the...

Role db_datareader will allow read-only access, but he will be able to see data as well. You don't say if he may see data.

There are a lot of views of...

Juanita,

Frank posted a lot of good examples. I had a similar question some time ago and I think I tested almost everything. The following works best for me in my...

Mark,

I think this thing needs Exchange Server on the network. I was not able to do it so far, we moved to Notes from Outlook 3 years ago. Instead I...

Noel,

I suppose sp_depends that Gregory does not like does use syscomments and I did not want to let Gregory re-create what SQL Server is already doing. I don't know what...

Gregory,

No parser is perfect!

Here is what I would probably do:

First, read the following scripts from this site

http://www.sqlservercentral.com/scripts/contributions/1074.asp

http://www.sqlservercentral.com/scripts/contributions/692.asp

MetaData_TableDependenceOrder

And see if they can help you. If not, then:...

Emanuel,

First, it is OK to run 6.5 and 2000 on the same machine. Actually, my 2-machine upgrade did not run, but the the one where I have both SQL 6.5...

Gregory,

Try sp_depends

"Displays information about database object dependencies (for example, the views and procedures that depend on a table or view, and the tables and views that are depended on by...

Look,

I did have a case when a system support took LOCALSYSTEM account from the ACL on SQL Server and WINNT folders. It happened overnight. SQL Server could not start at...

Colleen,

It is a pleasure to see you here!

There was also several other objects that have to be re-create in 2000 completely, not only the ownership, like a couple of views...

David is right.

I answered for myself "Enable Database for Full-Text Search" before I looked at the list of answers. I, too did get it right from the suggested selection

Yelena

Brian,

Thanks.

I have our network support to take care of all firewall problems, I knew that we need 139 for Windows Authentication, I did not know that we did not need it...