I don't know this for certain, but I'm guessing that the input values are "set" when the query first starts, so the value is zero. IF you set the...

DKG - yes, SQL Authentication and the IP/Name with a correct user/password can be used. The name will not conflict with another, because each name ends with a domain...

I don't think there is anything special - you can connect to any SQL server if you know it's IP (or a resolvable name), port, a username and password... as...

Sounds to me like they've just placed it outside the firewall. Although this does make it visible everywhere, it also... well... makes it visible everywhere. I'd rather have...

InStr([start,] string1, string2 [, compare])

Hope this helps,

Chad

How about InStr([start,] string1, string2 [, compare])

Hope this helps,

Chad

I'm not sure I understand... are you trying to string together a series of parameters for a single report? For example, pick a country, then the region box fills...

The removedocument is out of order, but that was the only issue I found. I'm guessing that there is a bad character in the XML that didn't survive the...

Cool. I like it. I'll be using this frequently to quickly double check column types or foreign keys while writing scripts. Very handy, thanks!

Thanks,

Chad

A trusted connection is one that used a windows account to connect to the SQL Server (e.g. domain\user). Non-trusted connections use a username and password to connect.

Chad

I don't completely understand all of your data, nor what you are looking for, but lets see if this helps at all...

I'm guessing that you want to see a list...

Look in the SQL Server Log and see if it has additional information there about the failed login. If not, turn on login auditing for failed logins and it...

It is possible to replicate the results, Open up a query window to a database and type in "SELECT * FROM sys.master_files", then open "activity monitor" and kill the...

A few things you might try...

--Check that the backup file location and the path in the cleanup task are identical (not a mapped drive in one and UNC in another,...

I'm sure someone will have a better idea than this, but you can get around it by adding the exact content of your ORDER BY to the select:

SELECT DISTINCT zipcode

,city

,state

,CASE...