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...

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...

sudhirnune (1/19/2012)

---

I have a table which has a column (ISSUE_DATE) which is a date time Data type.

But for improving the Query Performance i need to Index the Table based on...

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...

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...

kurtwest (1/19/2012)

---

Is there a trick to using cut and paste on the T-SQL scripts people post on here? When I do cut/paste it makes one long line with all...

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...

if "using" means SELECT FROM that table, only way is by adding a trace so you can see who's selecting stuff from it;

for INSERt/UPDATE/DELETE, you could add a trigger which...

C# Screw (1/19/2012)

---

This sounds interesting Lowell,

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...

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...

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...

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...

the code from the post is filled with CHAR(160) instead of spaces; it was used to mainiian formatting...

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...

easiest way is to simply connect via the DAC: Dedicated Admin connection.

procs are not encrypted when connecting via the DAC.