Be sure this SMS account has rights to connect to SqL Server. It logs in like any other user of SQL Server.

See the other thread: http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=138256

You might try the compare tools from Red Gate and Apex SQL to see if they handle this.

I believe the autoval column in syscolumns has a value for identity coluymns.

Escape it by doubling them up.

select * from table1 where name like '%''%'

The user might own things that the role wouldn't.

There isn't a way to limit by user, only by total connections.

That is strange. Under what account does the DTS package run? Is is a sysadmin? Is your DB owned by sa? Does this happen if you run them interactively instead...

I'm not sure what you mean by shares. As far as logins, search sp_help_revlogin on MSDN and you can use that script to move logins for SQL 7 and 2000.

Nice complement and indeed I get lots of questions submitted, well not lots, but probably 1 of 10 is submitted. However, most people don't want to get credit because of...

I'm not sure what you mean? You can go back and answer the old questions.

We're also getting a book ready with previous questions of the day for sale. Look for...

Thanks, and since I'm posting, it worked, sort of

I agree with Adam. I knew that people would think the answer was wrong, but it isn't. This is a common source of problems in SQL Server, people see certain...

Profiler is probably your best bet.

We do run a monthly newsletter to summmarize everything that's come out.

At this point, we don't have a good way to give you an option and honestly if we went...