Viewing 15 posts - 24,166 through 24,180 (of 39,944 total)
Well, without more info, my advice would be to delete some stuff you don't need.
May 5, 2009 at 9:55 am
anyone out there played the game of Life? Know what a degree gets you there? It gives you a better start in your career at the beginning (although you're delayed...
May 5, 2009 at 9:54 am
jnobles (5/5/2009)
I'm still a senior in good standing after 30 years.
Not sure about that. After 10 years, most schools start removing credits. It's a business to them!...
May 5, 2009 at 9:42 am
Lynn Pettis (5/5/2009)
Okay, I may not have put the code in my post, but I did suggest the very same thing as well.
Apologies, Lynn!
May 5, 2009 at 9:38 am
Actually you'd need to be careful with my method either way. Since you don't know which table would necessarily get updated first, you'd need your triggers to check for matching...
May 5, 2009 at 9:37 am
You would issue a GRANT EXECUTE ON XP_CMDSHELL to the user.
However I'd recommend that you create a role and then assign the rights to that, allow the user to then...
May 5, 2009 at 9:34 am
If the login is getting continually locked, someone is still logging in with the wrong password. If this is a web app, you might need to restart the IIS app...
May 5, 2009 at 9:30 am
GilaMonster (5/5/2009)
Better idea, come down here in early Dec. You get a vacation...
on a plane. Isn't it like 42 hours to fly down there?
May 5, 2009 at 9:28 am
When a question is ambiguous and I've (usually) been chastised properly by Hugo for letting it slip through, I correct the question and then award everyone who has answered to...
May 5, 2009 at 9:22 am
Do you have an installation of SQL Server as a server somewhere?
May 5, 2009 at 9:16 am
noeld has a great solution, which I wish I'd thought of.
On the subscriber you'll have two tables that represent your indexed views. create a view over them.
select a.1, a.2, a.3,...
May 5, 2009 at 7:48 am
Well I thought that was a new one, but it seemed interesting with the update from the OP.
Definitely some creativity at work there.
May 4, 2009 at 3:43 pm
The issue you'll have is that this isn't a one time thing. With replication, the "tables" will be changing constantly.
The easy way would be to insert from one table, and...
May 4, 2009 at 3:42 pm
Where is the empty password? I can fix that. I don't see one in the code for the article.
May 4, 2009 at 3:36 pm
I'd still vote for 13 separate databases, and turn Barry's comment around. It's harder than one database, but not 13x harder. Just a little harder.
May 4, 2009 at 3:06 pm
Viewing 15 posts - 24,166 through 24,180 (of 39,944 total)