There have been a couple of threads recently where a set of values is passed in via a single parameter. The query then does a charindex() in order to "parse"...

The account on the SQL Server side, is it a local account? If it's a domain account, it won't work. It sounds like you have local accounts, but just checking...

Yes, the way I describe establishes a user User1 in the database. This is necessary first. Go into Enterprise Manager | Security. Click on the User1 login, right-click, choose Properties....

What is the size of the log files for the database in question on the two servers?

K. Brian Kelley, GSEC

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring

http://www.netimpress.com/

The SQL Server service, is it running under the Local System account?

K. Brian Kelley, GSEC

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring

http://www.netimpress.com/

I'm only getting the newsletter. I'll have to recheck my subscriptions.

K. Brian Kelley, GSEC

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring

http://www.netimpress.com/

I've used the solution myself and I think Andy Warren has suggested it once or twice. With an alias, the mapping doesn't show up in Enterprise Manager, hence the reason...

Log on to the SQL Server locally.

Start | Settings | Control Panel

Bring up the Licensing applet.

Select Microsoft SQL Server 7.0 as the Product and click on the Add Licenses button.

K....

You'll need to stop it manually. Proper steps are:

1) Copy source folder off of CD (\x86\data)

2) Remove Read-only attribute from folder and files

3) Run rebuildm.exe

The issue is a known bug...

Yes, unless the login is a member of the sysadmin role for the server. Does the login only have dbo rights to a particulr database (or databases)?

K. Brian Kelley, GSEC

http://www.truthsolutions.com/

Author:...

INF: How to Configure SQL Mail

http://support.microsoft.com/default.aspx?scid=kb;en-us;263556

INF: Frequently Asked Questions - SQL Server - SQL Mail

http://support.microsoft.com/default.aspx?scid=kb;en-us;311231

K. Brian Kelley, GSEC

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring

http://www.netimpress.com/

Don't check the Attempt to Repair Minor Problems as this is a known issue (well-documented). Most of the time SQL Server won't detect any issues and will go along just...

Go back and check the SQL Server logs from the time of the power outage and you can verify if SQL Server was shutdown gracefully.

K. Brian Kelley, GSEC

http://www.truthsolutions.com/

Author: Start to...

If User1 is a member of the sysadmin role for a particular SQL Server, that login will map into the database as dbo. That's why locally when you probably created...

Do you have the option of backing up the database to a file on the local system and then copying the file across? This would ensure, regardless of network problems,...