Kyle Schlapkohl (2/8/2008)

---

I would like to run an update statement within the sp_msforeachtable stored procedure, but I don't know the exact syntax. I think it should be something like...

EXEC...

With AWE enabled, you will never really know how much memory is "used". You can know how much is allocated if you use max server memory.

Without AWE enabled, yes task...

Your database users don't match up to your logins due to different SID's.

Try running this:

sp_msforeachdb

'USE ?

DECLARE @username varchar(25)

DECLARE fixusers CURSOR

FOR

SELECT UserName = name FROM sysusers

...

Correct

When I look at the files...

First and foremost, you need to look at your execution plans ... your problem could be one of MANY things at this point.

Run your query in query analyzer/management studio, with...

Long story short, the space is more or less reserved. Look at disk management before and after you take a snapshot. No space was actually used up for your snapshot....

I just want to create a synonym name for the database name ... which works on the master database.

But it looks like it doesn't work on any other database?

So I added a small step into my snapshot procedure, and am I missing something here? Can you not query a synonym for a snapshot database name?

CREATE SYNONYM synname FOR...

From a stored procedure, you'd have to use xp_cmdshell.

From a job, you could setup an Active X step and use VBScript to hit the command line with sqlcmd or osql.

You have to specify if you want to do it online ... which can only be done in enterprise edition.

Indexes, including indexes on global temp tables, can be rebuilt online...

I wonder if the procedure hasn't recompiled since your last change and is using an old execution plan? Might want to try doing a freeproccache for s&g's ...

Regardless, have you...

Synonym eh? Not a bad idea, hadn't thought about that ... We're getting ready to implement mirroring on our Warehouse for DR and reporting. I was planning to snapshot...

I see, I see ... if it would have simply been connections, than I could have given you a basic TSQL procedure to use.

Since you're going for more or less...

Is SQL Server Browser service running on the server in question?

What is the error?

Have you tried opendatasource?

Can you connect to the destination server from the source server?

Can you connect to the source server from the destination server?