Viewing 15 posts - 21,871 through 21,885 (of 39,824 total)
That's a great point. The cloud could be a private cloud, run completely by a company internally with their own staff. In that case, is there a reason not to...
October 25, 2009 at 9:23 pm
You can do this pretty easy in SSIS. Calculate the file name, change the destination dynamically based on the calculation.
October 25, 2009 at 9:21 pm
How did it fail? Any errors?
Check the sqlstp.log file on your drive. Or something close to that. Sort by time and look for it.
October 25, 2009 at 9:19 pm
Not necessarily. The leaf pages are moved, but not upper level ones. Potentially that means you could have fragmented intermediate pages that don't get cleaned up. I suppose, depending on...
October 25, 2009 at 9:18 pm
I'm with Barry. It's annoying, and a hassle.
However, with 2008, and some modern tools, intellisense makes this less onerous. no other disadvantages I'm aware of. I believe the name is...
October 25, 2009 at 9:16 pm
Please don't cross post. I am closing this thread.
October 25, 2009 at 9:10 pm
As Jeffrey mentioned, log size is completely dependent on the level and rate of activity. If you have users running in Simple mode, the peak may be smaller than in...
October 25, 2009 at 9:09 pm
How is security set? Is EXECUTE granted for the user? Or for a role the user is a part of?
Is EXECUTE denied anywhere, for the schema or procedure?
Public should...
October 25, 2009 at 9:04 pm
As you might have guessed, I'll be there. Likely working the door for the party 🙂
October 25, 2009 at 9:01 pm
Glad things are going well, Jack.
October 25, 2009 at 9:00 pm
I would recommend VBSCript to do this. The FileSystemObject can perform file manipulation and the ADO objects can connect to SQL Server.
October 23, 2009 at 5:24 pm
AFAIK, this is correct. You cannot detach a filegroup, only a database.
October 23, 2009 at 11:18 am
Pimane is correct, this is not intended to limit all queries. It is designed to limit resources when there is contention.
If no one is on the server except a single...
October 23, 2009 at 11:17 am
No issues. The Win 7 clients can connect to a SQL 2000 db. The clients are backwards compatible. It's the server code that's the issue in trying to install that...
October 23, 2009 at 11:15 am
Excellent comments, and thanks for the debate.
October 23, 2009 at 11:15 am
Viewing 15 posts - 21,871 through 21,885 (of 39,824 total)