Y, those are pretty simple DML operations, so either create an SP and run it in a job, or paste the query text directly into the job, or create a...

The connection is the highest level you can set the iso level. I've been on MS for a long time to give us DB-level isolation. Anyway, the short...

That logic is flawed on its face.

If you're using Windows auth, the DBAs have to have access to windows. SQL checks windows auth before it checks SQL rights. ...

I'm sure there are a number of reasons specifically, but who cares really? The prod box is beefier... doesn't that answer the question right there?

It's all good. Glad I could help.

Y, when the time comes you'll have to actually delete the group.

Make sure that your service accts are explicitely given sa or you'll be in trouble.

Otherwise, if nothing's owned, then...

Try building a query string with your vars first and then passing the query as a single var.

I just tried this and it works:

declare @sql as nvarchar(500),

@dbname as...

Y, having extra empty space in your DB wouldn't slow down your app.

ok, while I've never personally experienced this error it looks pretty clear.

I think what you need to do is take another full backup of the primary if you...

Is this on your workstation or the server? Are you able to bounce the box? I typically don't advocate bouncing prod boxes, but memory problems are difficult to...

Well, it sounds like the dev just grew the data to that size at one point and that's now the new minimum size of the file. Same with the...

I haven't tested it with SSIS, but with DTS it didn't preserve your formatting when you saved it as a file. So I'm not surprised that you're having the...

Well, that was a few yrs ago. MS if embracing virtual environments with SQL these days.

it's always best not to mix langs if you can help it. Way back when... when I was actually doing french support you really couldn't mix langs like...

I've never had a problem with my layouts not saving. However, in the past with DTS there were cases where your layout wouldn't be saved. How are you...