A few things to remember about standards ...

• There are always exceptions - plan for and document them
• They are 'living' documents - the only 'constant' in life is 'change'
• They are useless...

It does work ... you need to make the COLLATION between any 2 columns used in any relational operation th same. Below is you example modified a bit (it now...

If you are performing this fromQA then 1204 will add it to your output.

Aside from all the topical information posted (yes, you have to pretty much hit everything in this post) the absolute best things you can have in your tool box are:

• A...

Using either ISQLW or OSQL and invoking sp_start_job.

From BOL:

sp_start_job [@job_name =] 'job_name' | [@job_id =] job_id

    [,[@error_flag =] error_flag]

    [,[@server_name =] 'server_name']

    [,[@step_name =] 'step_name']

    [,[@output_flag =] output_flag]

Jus t one more thought ... what about a scheduled task ? You can create one without a schedule and just execute it on demand. I do it all the...

Not to my knowledge. However there are a few 'brute' force sql procs out on the web ... all of them need to be run as a 'sysadmin' ... a...

All good work arounds for the issue. Here's a couple of other thoughts. Does your server have anti-virus software ? It could be readin just the file name/header  in order to...

Here is something a bit more comprehensive:

1433 TCP

1434 UDP

3389 TDP --> used for support - RDP

445 TCP

445 UDP

135 TCP

135 UDP

137 UDP

138 UDP

139 TCP

This information was garnered using ethereal on a project through a firewall with a default access rule of...

I do not know for sure but logic is telling me that the limit is 2 Gb per instance on a server. My reasoning is as follows:

if you have one instance...

Also, if there are spaces in the name don't forget the double quotes ... like "C:\Program Files" ... If you're executing from xp_cmdshell you might try a DIR command in...

If the column names are the same in multiple tables you have two choices - aliasing or object qualification. Either one will do. We have some similar issues with 3rd...

There is also the sysaltfiles table in the master database that contains all database files ... here's a quick query:

select name, filename

from master..sysaltfiles

where fileid = 2

and name = 'your_database_name'

fileid =...

The more spindles the better <period> The only time when purchasing huge disks (146 Gb) pays off is in a SAN configuration where you can slice into LUNs and reslice...

I've seen this error before ... By chance is this table involved in some type of JOIN processing ? If it is, then it's the JOINed result table that is...