I had a similar situation with a developer of mine who needed to be able to restart jobs etc. Now, I have enough trust in him to allow him to...

Some readers in this discussion here mentioned "hating" underscores for object names. I do agree that initial caps is more readable, but there are circumstances that justify underscores. For example,...

I've personally developed an inhouse asp.net application that imports pdf's into SQL server. It's a departmental purchasing system, so it only has a couple users and it's within the confines...

Forget the question about the ownership chains. I read up on it.

Explain to me some more about the chain/permissions issues.

I'm not sure how being logged on as "(local)" affects the configuration, but for our SQL server links, when I check the radio button for SQL server, the option for...

In the past I've used NGSSQLCrack. I can't remember exactly how it does it, but it has worked for me in the past for situations like you are speaking of.

If you set up your sqlserver to startup with a domain account, and then you log in as that account, then the mapped drive letters will work for a backup....

Like with any documentation, it's only as good as it is updated. Knowing this, I don't require separate documentation, I have the programmers who write them, document it through comments....

We have free e-mail support with Microsoft on SQL server (due to our "Software Assurance" license agreement), so I finally set up a ticket with them.

They were able to figure...

I'm exeriencing the same problem. How did you get the hotfix? It looks like MS doesn't post it. You have to contact them. Did you have to do the same?

I never did solve the problem. Last month I even got a new server that is a dual-Pentium 3.0 Gh. -- a considerable upgrade from what I had. Since we...

I've had trouble with moving data over in the past. The problems I ran into were bad data. Access allowed some dates that SQL does not accept. I had a...

I've used the information from the following link to dynamically assign all dts packages with a certain owner, to another owner. It uses the same stored procedure, sdb.sp_reassign_dtspackageowner.

http://www.databasejournal.com/features/mssql/article.php/1461511

I've run into a similar problem myself. The TargetServersRole works well for most things. I had to give a user access to execute jobs, which targetserversRole did not include. I...