Viewing 15 posts - 6,046 through 6,060 (of 13,469 total)
i just copied and pasted my quoted command, and tested it in both SQL2005 and SQL2008, and i got results with no errors at all.
I'm not sure where your issue...
January 20, 2012 at 6:54 am
remember what case-Insensitive collations are used for: if i search for "apple' or "Apple" or "APPLE", i'd get results. that's perfect. now if i want to ORDER those results, i...
January 20, 2012 at 12:49 am
sudhirnune (1/19/2012)
But for improving the Query Performance i need to Index the Table based on...
January 20, 2012 at 12:16 am
you are all set buddy; the link and version i sent you works for 2005 and above, so that includes a 2005 to another 2005, if you were not...
January 19, 2012 at 12:58 pm
While we are on the subject of things that annoy us but cannot control...
there are a pair of stop lights near my house that take entirely too long to...
January 19, 2012 at 12:12 pm
kurtwest (1/19/2012)
January 19, 2012 at 11:53 am
I just tested this by toggling my Sandbox database's compatibility level, and it does appear in the default trace;
it shows up as an ALTER DATABASE event, with the whodunnit information...
January 19, 2012 at 11:23 am
C# Screw (1/19/2012)
I don't know how to add an IP address, but I think have seen you can get SQL to listen on multiple different ports.
So would...
January 19, 2012 at 9:35 am
hostname returns the machine name of the client;
i think he wanted to know if the client resolved the server address, for example as 192.168.1.200 as MyDB.MyFirm.co.uk vs OldServerName vs oldServername.MyFirm.co.uk
i...
January 19, 2012 at 8:50 am
I'll look for or create a script for linked servers;
the problem is the credentials for the remote user, if you identify one, cannot be scripted out, because they are part...
January 19, 2012 at 8:16 am
thanks drew;
it's actually inaccurate in a lot of other situations too, depending on the range between the two dates; that date -1 stuff works just for the date supplied in...
January 19, 2012 at 7:56 am
OLDCHAPPY (1/19/2012)
i get a boatload of errors with that script in SQL2008. 🙁
the code from the post is filled with CHAR(160) instead of spaces; it was used to mainiian formatting...
January 19, 2012 at 7:52 am
ok a correction. it's more than just the DAC, as i just double checked to make sure my post was correct.
you need to connect via DAC, and then use the...
January 19, 2012 at 7:08 am
easiest way is to simply connect via the DAC: Dedicated Admin connection.
procs are not encrypted when connecting via the DAC.
January 19, 2012 at 6:29 am
Viewing 15 posts - 6,046 through 6,060 (of 13,469 total)