Search results for query: *

Really just a Friday afternoon curiosity. A co-worker executed a stored procedure and received a return value of -7. They asked me what that meant. When needed I've checked return values to make sure they are zero or non-zero for success, but never really cared what the actual value is...

I have a Windows 2003 Standard Edition Server with a 2 drive raid 1 configuration. The logical drive is partitioned into 4 partitions (C:\, F:\, T:\, and X:\). One of the hard drives failed. After replacing the drive and getting the server back up and running, SQL server 2005 no longer sees...

We have a pretty basic interface set up with numerous vendors. We set up a linked server based on their company name. They create a stored procedure on their server that has the correct name and parameters. There are about 20 potential vendors that could be set up, but at any given location...

Does anyone have any thoughts or recommendations on MS SQL programming related sites on the web? I've been looking at signing up for a membership at sswug.org. Mike Reigler Melange Computer Services, Inc

I'm trying to select the commandId attributes (as bigint)out of an XML document without knowing the name of the element the attribute belong to using XQuery, but being new to both XML and XQuery, so far I haven't had much success. Any help would be greatly appreciated. For example return...

I'm trying to programmatically script out the default constraints from tables in one database to update copies of those tables in another database. I have the table name, column name, and constraint name from syscolumns and sysconstraints, but I haven't been able to find where the default value...