Viewing 15 posts - 406 through 420 (of 2,647 total)
PaulB-TheOneAndOnly (7/26/2012)
SQLKnowItAll (7/26/2012)
However... I could maybe put each customer into their own schema? and build those schemas on their own filegroups? Hmm... Just thinking out loud.
Why don't you push...
July 26, 2012 at 9:53 am
You have no end of line. You have to add something (depending on your file) like a \'n' (remove the single quotes around the n):
10.0
9
1 ...
July 26, 2012 at 9:44 am
Please tell us what you did so that others can resolve the problem it it happens to them.
July 26, 2012 at 9:38 am
Is SA your only login? There must be others that work?
July 26, 2012 at 8:59 am
PaulB-TheOneAndOnly (7/26/2012)
SQLKnowItAll (7/26/2012)
1. Std. Ed.
Do poor's-man partitioning, a table by customer exposing the bunch as a view joining all of them.
SQLKnowItAll (7/26/2012)
July 26, 2012 at 8:56 am
Log in as someone who is not SA and fix your trigger.
July 26, 2012 at 8:50 am
PaulB-TheOneAndOnly (7/26/2012)
SQLKnowItAll (7/26/2012)
PaulB-TheOneAndOnly (7/26/2012)
In terms of restoring a subset of the database I would start by backing...
July 26, 2012 at 8:46 am
PaulB-TheOneAndOnly (7/26/2012)
In terms of restoring a subset of the database I would start by backing up subsets...
July 26, 2012 at 8:27 am
Yeah, my first thought is to set up some auditing triggers and put some kind of identifier to allow them to restore along several different measures; i.e. a specific item...
July 26, 2012 at 7:43 am
Go to the command line on that machine and type "net use M: \\10.0.0.12\Master /user:administrator password"
When prompted, press Y
July 25, 2012 at 2:59 pm
Why not just pull the filenames into a table and do a left join. 3.5 million rows is really not that much data. I can load a million rows into...
July 25, 2012 at 2:56 pm
Not sure why you can't attach the file. either use the IFCode shorcut for img or just click on the "edit attachments" button on the lower right of your reply.
July 25, 2012 at 11:34 am
So, you are talking about the arrows that show the direction of the connection?
July 25, 2012 at 11:30 am
What version of SSMS are you on? I don't have either of those windows...
July 25, 2012 at 11:24 am
Tobar (7/25/2012)
What I...
July 25, 2012 at 10:54 am
Viewing 15 posts - 406 through 420 (of 2,647 total)