Viewing 15 posts - 5,641 through 5,655 (of 9,722 total)
Warren,
At the very least, the devs would need security admin perms, if not db_owner / sysadmin to use this proc.
June 28, 2011 at 10:40 am
Stefan Krzywicki (6/23/2011)
Brandie Tarvin (6/23/2011)
I'm going to be running some Shadowrun events for Catalyst as well...
June 24, 2011 at 6:38 am
Are any of you people going to be a GenCon, pretending to be geeky gamers?
I'm going to be running some Shadowrun events for Catalyst as well as signing books for...
June 23, 2011 at 12:40 pm
SQLRNNR (6/23/2011)
Gianluca Sartori (6/23/2011)
....BTW, this THREAD stopped being related to the original question maaaany posts ago. Now it's a sort of watercooler thread. Welcome aboard!Is it watercooler or scuttlebutt?
Yes... @=)
June 23, 2011 at 10:34 am
Ninja's_RGR'us (6/23/2011)
MOVE c:\backups\*.bak D:\backups[\].
I'm 99.9% sure that you don't need a destination name for the...
June 23, 2011 at 10:32 am
Dan-Ketil Jakobsen (6/23/2011)
Thanks Brandie, that solved my issue. 🙂
Which question solved your issue? I'm curious.
June 23, 2011 at 10:32 am
Don't you need a destination file name (not just a folder) to make that command work correctly?
Does SQL have permissions to write to that destination?
June 23, 2011 at 9:05 am
Failover?
What are you trying to do? Cluster failover, log shipping, database mirroring?
We need a little more information, please.
June 23, 2011 at 8:58 am
Not sure I understand your question.
I'd drop and recreate the stored procedure with those commands added to it.
June 23, 2011 at 8:56 am
1) Backup the database, restore it to the new machine
2) Add 5 new files to your default filegroup, each pointing to a different drive.
3) Move the data from the...
June 23, 2011 at 8:04 am
Jeff Moden (6/23/2011)
Craig Farrell (6/20/2011)
Don't even get me started on the incredibly interesting answers I've gotten for "Describe two differences between Truncate and Delete".
BWAAA-HAAA!!!! Such easy questions! 😉 Everyone...
June 23, 2011 at 7:37 am
Oh, wait. I forgot about table partitioning. You could probably do that.
1) Backup the database, restore it to the new machine with each of the existing files on a different...
June 23, 2011 at 7:25 am
Your title indicates something different from what your post says. Are you dealing with multiple files in one filegroup or multiple filegroups?
EDIT: The reason I ask is that you can...
June 23, 2011 at 7:21 am
Viewing 15 posts - 5,641 through 5,655 (of 9,722 total)