Thanks for the response. Basically what I am trying to do is to be able to take nmap data which has xml file ouptput and import the data into 1 table...
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...
Thanks very much guys, I appreciate it!~
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...
Yes I understand, but if the NT Machine is a standalone (Not a member of a domain) and there is no way to put in credentials in the DSN when using...
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...
Thanks for the input guys, I am looking into different options at this time. Thanks again!
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...
Thanks Satya! For the rest here is some more info from SQL Server Magazine: Autoclose is available in all editions of SQL Server 2000. The amount...
Has anyone seen this before. I have restored a backup db from production reassociated the correct logins/users and it seems to be functioning....
Satya- Thanks for the info. It should only be about 20 Concurrent users using reporting Services at any one time, But I did find a separate box to...
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...
Absolutely it did. Thanks for the direction!
Luis- Thanks, but The tables do not have teh same schema(You need that in order for Red Gate to work- I think that is more for prodution/Dev issues....
Satya- Thanks for the reply. I am using OPENQUERY to get the table into SQL. I guess I should have just stated that I am looking to compare 2...
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...
Separate names with a comma.
