I'm pretty sure Jonathan is correct and you can't modify @timestamp. I've seen others have a job or other process to rename the file and just strip off the time.

Sue

Using the with grant option works differently when it's done at the object level vs database/schema level. You would need to use the AS clause and specify the role as...

You can delete a stored procedure using SQLCMD but I can't tell exactly what you are doing in this one.

If you have a script to run, just call that using...

You can have one distribution database on one instance for all of the publications or you can have multiple distribution databases on one instance. The distribution database takes on a...

And it also notes how it isn't reliable (but doesn't use that wording) and mentioned how not all changes get propagated and you need to open up the maintenance plans...

Thanks guys. I don't have a problem dynamically creating a back up location.  What I'm attempting to understand is how you then take that dynamic path and add it...

If you renamed your PC, you really want to clean that up in SQL Server or you will hit odd issues.

You can see the name is sys.servers - server id...

You'd probably want to start with this list of things for troubleshooting steps:

Troubleshooting: Timeout Expired

Sue

Example: \\fileserver\sqlbackups\auto backups\XX\Full Backups I need the XX to be the same value as the value returned from "SELECT @@SERVICENAME" Is this possible or does multi server administration assume...

I can't find a current reference in Microsoft's documentation but here is an old one which states:

Service packs are cumulative. Each new service pack contains all the fixes that are...

Service packs are cumulative so they include fixes from previous service packs. Service Pack 4 won't list all the fixes from Service Pack 1, 2 and 3. Just those new...

MsgID 50000 is usually the error number thrown when you do a raiserror without specifying an error number. You may want to look at the code (or have them look...

So the agents are still there - are the jobs still there as well?

Check for the publication in the distribution database in the table MSpublications. Check for agents referencing the...

It generally happens when logins are deleted without deleting the users in the database or when a database is restored and the users in that database have no matching login.

If...

Yes, SP4 would include the fixes from previous service packs.

Sue