Viewing 15 posts - 121 through 135 (of 251 total)
You could quickly run into variable size limitations doing this in T-SQL if your data comes back with any significant number of rows. If you are using ADO you could...
March 10, 2003 at 2:43 pm
I have the SQL 2K System Tables Map html help file, and it does not have the definition for the sysxlogins. Does anyone know where a definition of this table...
March 10, 2003 at 9:28 am
quote:
I remember trying to track what B$ and D$ were
Software dating yourself there too Brian(or...
March 7, 2003 at 1:09 pm
I would as an easier alternative make the old server names in DNS cnames that would point to the one centralized server's "A" record. No fuss, no muss. Plus I...
March 7, 2003 at 11:54 am
EXEC sp_MS_marksystemobject @objname = '???' should be able to marks them back as system objects...
Tim C.
//Will write code for food
March 7, 2003 at 9:46 am
Hmmmm, you right David, I had tried doing this exact thing before withought using a global cursor, and it did not work, or I could not get it to work...
March 7, 2003 at 9:21 am
David is roght on the mark, by executing "TEXT" queries you actually slow yourself down. SQL server goes through a series of checks to find out what it is you...
March 7, 2003 at 8:58 am
David is roght on the mark, by executing "TEXT" queries you actually slow yourself down. SQL server goes through a series of checks to find out what it is you...
March 7, 2003 at 8:56 am
Red-Gate has another product while not as useful as SQL Compare does make life easier with static tables. It is Data Compare. Also, while SQL QA is my editor of...
March 7, 2003 at 8:45 am
David, minor code change to get your code to work. Without declaring that cursor global the scope of it would be limited to the dynamic sql. Chris was on the...
March 7, 2003 at 8:40 am
Thanks guarddata, you should be able to install the MDAC upgrades at http://www.microsoft.com/data and it would work fine. I reccomend either the MDAC 2.7 SP1 or the MDAC 2.6 SP2...
March 6, 2003 at 10:23 am
I hope you intention to be able to use named parameters is so that you can
modify the stored procedure signature at a later date. If other people are using...
March 6, 2003 at 8:50 am
What you are looking for guardata is the NamedParameters property on the command object, by setting it to true, ADO will use named parameters. By default this property is false.
From...
March 6, 2003 at 8:32 am
quote:
In order to get the certificate, you have to fill out a certificate request, and that's where IIS comes in.
February 28, 2003 at 9:44 am
I agree with everyone here that you should keep your SQL box pristine, but if
you MUST absolutely have IIS on the SQL server there is a tool that can...
February 28, 2003 at 8:44 am
Viewing 15 posts - 121 through 135 (of 251 total)