Are you logged in as SA or with admistrator rights, or did you make changes to your login or the procedur itself?

"Don't roll your eyes at me. I will tape...

Does @@spid actually work in a trigger, I thought triggers actually ran under the scope of system and not the connected user so @@spid doesn't work in a trigger?

"Don't roll...

When in doubt run sp_dropuser against the database. Usually you see this when you do sp_attach_db ot restore a backup from another server. The is apparently another process to map...

Merge replication requires that the tables must have a ROW GUID, see "How Merge Replication Works" in SQL Books Online for more in depth info.

"Don't roll your eyes at me....

Let us know if any issues come up for future reference.

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

Should not unless they are using MSDE and I don't think there are any common components between them. For safety thou I suggest either check with DELL, make a backup...

Oh and if you are just wanting to open an XML to view raw then just open as text as that is all the raw XML actually is, the format...

With 2000/XP see the following links the first pertains to HTML XML references and the download http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnoffxml/html/ofxml2k.asp?frame=true the next is an article HOWTO: Automate Word to Perform a Client-Side Mail...

Th only other way I know a user would be able to shutdown the server is if they have an account on the domain or box with suffient rights to...

Sorry, you need to do this way that way you know what table Indexes are for.

sp_MSForEachTable '

SELECT ''?'' AS Tbl

EXEC sp_helpindex ''?'''

"Don't roll your eyes at me. I will tape...

Any time you need to do for all tables sp_MSForEachTable is great. FOr you needs you do this.

sp_MSForEachTable 'sp_helpindex ''?'''

"Don't roll your eyes at me. I will tape them in...

Is this any work flow screen or a specific one?

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

If you found something you can directly attribute it to like Access Denied then make sure you fix the access. Otherwise unless it happens again I would not worry too...

Look up Server Roles in Logins in BOL. A person with the proper role only can stop and start. These roles are found by opening Login Properties in Enterprise Manager...

1) You can use EM to Import/Export objects between servers, choosing specific objects.

2) You can right click in EM and choose all task then script objects and script all the...