Viewing 15 posts - 7,951 through 7,965 (of 9,720 total)
I know of no way to only allow one connection via a login. Through the server properties, yes, but not on the login level.
However, you could give this person access...
May 12, 2010 at 11:31 am
Whisper9999 (5/12/2010)
May 12, 2010 at 11:28 am
Server-side profiler trace is your best option to get all the data you want and not miss any logins.
Make sure to include the TextData field to get the procs and...
May 12, 2010 at 11:21 am
You are not off base. I/O is basically reads & writes to the hard drive. If your disk controller went whooey recently or if there's another problem bottlenecking your I/O,...
May 12, 2010 at 11:17 am
If I'm not mistaken, Data Mirroring uses the Service Broker to transmit data over to the mirror. So everything is queued up as messages that are read into the mirror....
May 12, 2010 at 11:14 am
Try this from different workstations and from the server directly. Do you still get the same error?
What edition & version (including service packs) of SQL Server are you using?
May 12, 2010 at 11:12 am
If someone asked me about the accuracy in an interview, my response would be "I don't know. I've never needed GetDate() or related functions to be that precise. If and...
May 12, 2010 at 10:33 am
GilaMonster (5/12/2010)
How does a DBA can plan or prepared for such a scenario?????
Same way you plan for any other scenario. Examine the risks, the chances of it happening, examine the...
May 12, 2010 at 7:36 am
2cams (5/10/2010)
The vendor thought we were complaining about a performance issue which there was initially. We re indexed the database and updated the stats
Re-indexed as in recreated the ones that...
May 10, 2010 at 8:51 am
That seems to be an awfully low number of allocated pages. Did you run this after hours or during business hours?
Also, did you run it while the queries you...
May 10, 2010 at 4:46 am
Ah, I thought it was something specific to the code that you could point me to.
May 7, 2010 at 10:31 am
CirquedeSQLeil (5/7/2010)
May 7, 2010 at 10:21 am
krypto69 (5/7/2010)
I think I figured it out...
Could you share so that future readers of this thread know what to look for?
thanks brandie
You're quite welcome.
May 7, 2010 at 8:42 am
rustman (5/7/2010)
The password will still be visible to someone even if it is passed in during execution either throught the command line or the config files.
Depends on how that...
May 7, 2010 at 8:40 am
So far as I know, and I could be wrong, you can't Fuzzy Group without a basic Fuzzy Lookup. Which tells me SSIS has a built-in Lookup feature on the...
May 7, 2010 at 7:59 am
Viewing 15 posts - 7,951 through 7,965 (of 9,720 total)