Sounds like you might have to do it manually, then. Try creating a login for your domain account and adding it to sysadmin. Then use SQL Server Configuration...

If it's a single transaction that's causing the log growth, increasing backup frequency won't help. You'll need to rewrite the transaction or ensure you have enough disk space to...

Something like this:

SELECT 'USE ' + name + ' EXEC sp_addrolemember ''db_datareader'', ''myusername'''

FROM master..sysdatabases

That will generate the SQL to add the user to the role in each database. This...

You'll be looking for the COALESCE function.

John

You're very fortunate to have this problem on the day the latest article in the transaction log stairway[/url] is published.

John

That will always make mistakes since you haven't declared @where.

To solve your problem, please search this site for "running totals". You should be able to find something that you...

Mike

It sounds as if you didn't use SQL Server Configuration Manager to make the change. Maybe you used the Services applet instead? Try using SQL Server Configuration Manager...

Try the GRANT command. You can use your favourite search engine to get the syntax.

John

The best way to find out is to try it. You'll probably learn something you didn't know along the way, as well.

John

The other sql server? I'm confused. Please will you give a brief overview of what each task in the package does on what server? Also, did you...

You say you're exporting "some of these data", so not the whole table? What query are you using to filter it out? Is the destination database on the...

You haven't provided many details, but one thing to look at is the context that the package runs in. When you run it from Visual Studio, it runs as...

Yes, once we get DDL and sample data for InningsBowlingDetails we should be able to rewrite that subquery quite easily.

John

If you could explain how you decide what are the best bowling figures for any one innings, this should be quite easy. For example, what order what you put...

First of all, why aren't you backing up msdb? Second, if you know you're going to want to access job history from a month ago, then maintain the data...