"+" is the string concatenation operator in T-SQL.  If the table columns aren't character, you'll have to CAST them.

Greg

Sajan,

You could look at sp_drop_dtspackage in msdb.  Remember that only the package owner or a member of sysadmin can drop a package.

Greg

Run profiler to record actions in the database while the application is being used.  Be sure to capture the object name and type.

Greg

 It's a SQL Server Agent setting.  Right-click on the Agent in EM, select properties, Job System tab.  You can choose whether or not to limit the job history log...

It's a SQL Server Agent setting.  Right-click on the Agent in EM, select properties, Job System tab.  You can choose whether or not to limit the job history log size...

Joel,

Can you provide some more details?  If the app is executing dml statements dynamically, the tables will be named in the app itself.  If it's executing a stored procedure, the...

Terry,

See if you have a role called TargetServersRole in MSDB.  It's an undocumented role use for multi-server administration.  If it's there, you could add the user to the role.  You...

I already get 4.5 weeks of vacation a year (plus sick leave), have the flexibility to use it, work a half day every Friday, have an easy bicycle commute, have...

Carlos,

See my reply in this thread:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=110&messageid=232301

Greg

Run this query in the database:

select u.name,o.name

from sysobjects o, sysusers u

where o.uid = u.uid

order by u.name

Greg

Paul,

You said you created a new database then restored.  Try restoring without creating the database first.  See "How to restore a database with a new name" in BOL.

Greg

Thanks for the explanation.  This must be run when a user starts Query Analyzer also because I don't see all databases in the object browse when I log on as...

I stand corrected.  Now that I've looked at sp_MSdbuseraccess and the MS article, I understand how it works.  Tim, does your modification hide databases with the guest user, also?  That's...

No, you can't hide user databases in Enterprise Manager.  You can create a named instance for each customer or you can provide a front-end app that only shows the customer's database.

Greg

I learned this from the book, "Inside SQL Server 2000" by Kalen Delaney.  I don't know anybody who digs into the details like she does.

Greg