I am really struggling with this as I do not have any great knowledge of XML. I am reading as much as I can but I am looking for a real simple how to...
Hey guys- I am trying to find out which records in a field have lowercases where they should be all capital letters. Example- Select * from...
I have a SQL 2000 DB on a standalone Windows NT server. I need to connect ot it using NT Authentication. Iss it possible to even do this? WHen I try...
Good Afternoon- I have an Equipment table that has prices. Some Equipment pieces are attachments that have a parent ID. EQ_ID EQ_Price...
Hey all-<br /><br /><br />I have a dts package in which I am trying to do a straight copy from a DB2 database. I get the following error: <img...
Good Morning all- I am recieving the following error which I haven't seen before. It happens during a transform/pump from a flat file into a DB. It...
Has anyone seen this before. I have restored a backup db from production reassociated the correct logins/users and it seems to be functioning....
Good Morning- I was wondering if anyone has any performance metrics on what kind of additional load that Reporting Services puts on a SQL server. I...
Hey guys- Has anyone seen this one before? I right click a table in EM and select Open Table>Return all rows. My result set is about 5,000...
Good Morning- I was wondering if there is a effecient way to accomplish the following: I have 2 Databases. We have one table on a DB2 database that...
I looked through the previous posts but can't find an answer that fits exactly. I have been playing around with Cast and Convert but still get...
I have a query-listed below and want to know if there was a way to add a column that increments (Like an identity column) at the end. The numbers at...
Good afternoon. Is there an easy way to get the following task accomplished? Is more than one table necessary? Any help would be appreciated. Thanks!...
Hi- I would like to ask a quick question- How do need to accomplish dealing with the quotes around the dates I need to enclose the string but also...
This should be an easy one for someone(Other than me!) Thanks for the help! I am trying to accomplish the following: Update AM_Hist set...
Hi- I have an excel spreadsheet that I want to poulate with data via DTS. What I need is the previous data to be cleared from the spreadsheet...
First of all. Happy Holidays to everyone, and good luck in 2005! I am trying to get the middle of a string. I have a 10 digit phone number and need...
Can someone point me in the right direction for an ActiveX Task. I am not very profecient in VBScipt. As a part of the DTS package I want to move a...
I am a little stuck, can someone help me out? I have the following query: INSERT INTO Interface_File (ClientNumber, Location,...
Good afternoon- I have created a couple of command line DTS executes ( From the DTSUI utility). I am trying to allow a user to execute these...
Separate names with a comma.
