Florian Reischl (5/20/2009)

Grant Fritchey (5/20/2009)

Hey! Don't laugh at me. Just tell me what it is.

I'm starting to feel like Earl in Tremors:

"Hell Earl, everyone knows all about...

Hey! Don't laugh at me. Just tell me what it is.

I'm starting to feel like Earl in Tremors:

"Hell Earl, everyone knows all about these things. We just...

Yeah, based on the behavior so far, that's about what I would expect. It's like some kind of alias short hand, but it doesn't work for strings. If you try...

Weird isn't it? I've searched through the syntax in BOL and several books as well as a Google search. I can't find anything that references this type of syntax. I'm...

Wow. I didn't realize that reference would be completely missed. Not that I know squat about the actual Woodstock. I just saw the documentary. There was a long, rambling, silly...

ANNOUNCEMENT: Pay attention everyone. We've just been informed that there is a problem with the brown SQL statements. So we need you to stay away from the brown SQL statements....

Alvin Ramard (5/20/2009)

You remind me...

You can look at the script being used by SSMS, just click on the script icon. That should allow you to figure out what it's doing differently than you.

How big are your databases? You might check the scheduler on the job, it could be running this query lots of times.

One question about the code:

TO DISK = N'C:\Base backup'...

You can quantify the differences. Get the execution plans first. That will show you where the changes are occurring between the execution without the function and the one with it....

You can run the script from anywhere that you have a utility that can connect to the database and run the script. Nothing that comes with a Window Server install...

We hit something similar and it was a security issue. The service is running, but the error says it isn't, well, that's because the security context wouldn't allow it to...

The changes to the query could come from several sources, but I'll just address two. If you were changing the parameters, you may have hit upon a set of parameters...

I'd say yes, you should follow directives from on high as long as those directives are given with the full understanding of the implications. It doesn't sound like this is...

I don't want to get into the USB discussion, but I'd recommend having a single backup process for the server. It should backup the databases seperately, yes, but you should...