David,

I have some case-sensitive SQL Server 2000 databases, running Lawson 9. A few adjustments are needed in some of the script syntax, if anyone else is running a case-sensitive...

Ram,

English was the language that the people read and wrote that came from England in an effort to seek religious freedom from the Church of England. It has been...

More data on the book recommended by Jim Russell.

The Elements of Style, Fourth Edition (Paperback)

by William Strunk Jr. (Author), E. B. White (Author), Roger Angell (Foreword)

Paperback: 105 pages

Publisher:...

I agree with Matt, Steve and Scott.

After completing the MCITP (DBA) track, I will be pursuing an MBA. With a Bachelors in Information Technology and a Bachelors in Management...

David,

Thanks for taking the time to put this article together. I am looking forward to Parts 2 and 3!

ToyoGT,

Yes, sp_revokedbaccess can be used to drop users from a database.

Here is an article that gives code to identify Windows Users and SQL Users that are orphaned, and then gives...

Brandie and Markus,

I second the Thanks! Thanks! I have just begun to work with SSRS in SQL Server 2005. I have used Crystal Reports for quite a...

Steve,

I think an option 4 would be more viable for your situation. I have implemented the sqlcmd/.bat file via Windows Scheduler technique on our single SQL Server 2005 Express...

Here are some notes regarding Oprhaned Users:

-- Check for Orphaned Users for database .

USE ;

sp_change_users_login 'report';

-- If you already have a login id and password for this user,

--...

If any of the system databases need to be moved to another drive, the simple "detach" method will not work.

The Microsoft Knowledgebase article below is good for SQL Server 7,...

One method would be to build 150+ Linked Servers from your centralized SQL Server machine, that uses dynamic SQL to run the same query/stored procedure against all of your 150+...

Jeff,

No problem! It is people like you that have inspired me out of my "lurker" shell on this forum to get active and start replying to postings on how...

Thinky,

More notes for reference later.

Note that the @provstr line may have "wrapped" in the forum posting, it needs to be a single line when being created in T-SQL.

http://msdn2.microsoft.com/en-us/library/aa259589(SQL.80).aspx

Use...

Thinky,

Your Provider String looks to be lacking some information. Start here ...

Creating a linked server to DB2 using Microsoft OLE DB provider for DB2

http://support.microsoft.com/kb/222937

Also note that...

Several days of trial and error got us the proper driver combination.

I ran this by the other DBA as well. We have not have any issues with UNICODE with the...