I would not export in Excel, especially with text fields. If you for some reason can not connect directly from one SQL server to another, I would export to CSV...

Remi,

You are certainly right. Your way should be much faster.

My query runs towards a table that will not probably be very big. It contains only current records that will be moved into...

Hi,

I initiated a similar discussion several days ago, and I got many good answers how to get just a date out of DateTime. I am doing like this now (I...

Hi,

You may try to use WMI objects to do that from VBscript.

Yelena

John,

It is a good idea. As someone said, the more complex way they design it the more your manager values you for being able to work with it.

Yelena

William,

I do understand that you are checking if there are - at the certain positions. Please, explain why are you using right(left(@unique,9),1) for example, not substring(@unique,9,1)  unless it is just...

Hi,

What do you mean "correct answers"? I and many of our friends can successsfully argue on each one.

For example, my correct answer to 5 as we do in production...

Thanks. This may (or may not) resolve a couple of mystery connection drops that one of our port admins discovered in his monitoring tool 

John,

It is so COOL!

The only thing: do you know how I am loosing one day? Today is Jan 18 2005 and

GetDate() returns 2005-01-18 12:07:19.863

select cast(GetDate() as Integer) returns 38369

select...

It does not limit the number of connections. It limits the number of connections by ONE user. Does someone know if a typical Denial of Service attack uses a security...

Kathi, Julian, Frank and Brian,

Thanks!!! Those are great examples.

I new I had to ask real developers. I am sure aware about year/month/date format being great for sorting, and if...

Brian,

Do I understand correctly that "This forces the instance in question to tcp/2433"  means that if I want to hide the instance but have programs still be able to...

Frank,

Are you talking about the Name field which is the logical name and could be the same or about Filename field which is a path and should be different?

Brian,

Thanks. I tested and it worked for me. I was able to get the text of system SPs. All- do not forget to change the query options under Results -...

Raymond,

That was a good test. The fact that the tool was not running at the time of your test tels nothing unless you are sure NO Background processes fro that...