Viewing 15 posts - 706 through 720 (of 1,583 total)
Of course it is possible, for DR site you should have mirrored hardware (the same) - so if you can put 100 DB's on your production site, you should have...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 5, 2013 at 10:39 am
If a DOMAIN account is the db owner and that account is deleted/disabled (for whatever reason), and Agent Job tied to it will fail, and any database owned by it...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 5, 2013 at 10:37 am
Is this a fairly "busy" OLTP situation or is there little activity throughout the day? If the publisher is a busy server I wouldn't recommend using triggers or they...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 5, 2013 at 10:17 am
The original post for the question had SELECT * FROM #TEST WTH(NOLOCK) which was all that was needed to answer the question, in the "blurb" that provided the answer, I...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 5, 2013 at 7:02 am
Did this work? I'm looking at attempting the same thing...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 4, 2013 at 9:30 pm
Yes it is possible. But for the most part CPU percentages (Min/Max) is set up as a whole. Eg. If you set a particular resource pool up to...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 4, 2013 at 8:22 pm
As a test, on the external hosted Perl server, can you open a telnet session and connect to the internal IP address of the SQL Server?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 4, 2013 at 8:04 pm
My apologies I believe I misunderstood you from the start
When I was developing my code I was running it on a computer on the same network as the server...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 4, 2013 at 8:03 pm
csalazar-607991 (3/4/2013)
In the past I had problems with BCP because when I try to copy the data to a file some times SQL introduce returns between the data and when...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 4, 2013 at 7:44 pm
It was in the first response to your post - OPC.Three gave you a script to run
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 4, 2013 at 7:36 pm
2 I don't see the Data Access option in Perl. So I can't set it to true.
This is an option on the linked server to the Perl Server?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 4, 2013 at 1:42 pm
Is it possible this user has a SQL Agent job running under their credentials?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 4, 2013 at 1:28 pm
If you have a query window open in SSMS and leave it open, your session stays on the server until the spid is forcibly closed (killed), the user closes out...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 4, 2013 at 1:17 pm
Your command will work, there's just a whole bunch of things to think about: First thing that comes to mind is that the entire process will be logged and...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 4, 2013 at 1:13 pm
If space isn't an issue, I'd restore a backup to the other server and drop the things you don't need, keeping only that table
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 4, 2013 at 1:05 pm
Viewing 15 posts - 706 through 720 (of 1,583 total)