Hi folks, I'm cleaning up temp tables that I have started creating back in 2002 to present. However, I don't remember anymore if it's mine or not. I...
Hi folks, We have a DTS job that data pulled from MSSQL to a printer. When I run the job myself, it prints out. But when I schedule the job, it...
Is MSSQL 2000 stable on Advanced Windows 2003 operating system? Has someone done it? Are there things that needs to be done on the 2003 operating...
ok folks, we can't figure out what's wrong. Our programmer built an MS Access application and it connects to an MSSQL server on the same segment....
Ok folks, I don't know if this is the right forum. We have an MSSQL cluster. Then we also have a webserver running on IIS5 on Windows 2000. Everytime...
Hi folks, I don't know if it should be posted here. Here is the exec plan http://img254.imageshack.us/img254/2479/execplanyy5.gif The WHERE...
hey folks, We have a DR server with 2 nodes on a cluster. We need to move it to a different state(IL to CA) due to the colo being closed here in IL....
We have DTS packages running on SQL2000. There are plans of moving to SQL2005. Do we have to convert our old DTS package so that it will work with...
Hi folks, I need to find the total lenght of our data in a field that has been defined as TEXT. The len function does not work. Any function will be...
Hey folks, I need to steal some of your ideas. I was tasked to merge 2 databases. The schemas are the same but I will have to doublecheck again. I...
I would like to know if it's recommended to use views with bcp to create a text file? The table has 80 fields with 2.5 million records. I will be...
I need some ideas. I would like to know the most efficient way of exporting data on a huge table to Oracle. What I'm currently thinking now is by...
hi folks, I've never written a trigger yet. I will read up on it later. Here is what I'm planning to do and I would like to know if triggers are...
Hi folks,<br /><br />I don't know where to post this. I don't know if it should be here or on the DTS <img src='/community/emoticons/emotion-1.gif'...
I remember seeing an article before but I couldn't find it anymore. It talks about a query, a stored procedure that will show db growth. We are...
Hi, I need some guidance regarding updates with ROWLOCK. I'm studying this...
hi folks, I'm reading the BOL to find a function that will display my user id for my current connection using SELECT query, I've tried those...
I was talking to a vendor and he was telling us that it's bad to setup a DTS package at the same time. However, my point is, this DTS packages modify...
I'm being asked to create a scheduled DTS package that will print data to printers, I would like to seek some assistance on how I would be able to...
I need some help folks. I would like to know on how I would construct the sql query using group by. For example, table _temp_table contains 10...
Separate names with a comma.
