Good morning folks, I just finished installing SQL Server 2008 Express. What is the equivalent of Query Analyzer, Enterprise Manager and Profiler for...
Good afternoon folks, I chatted with a friend last night. He's also good in sql but not sure which one. He is also the person who does the...
Hi folks, I need some guidance. I lost my job. I would like to study clustering. I would like to know if someone can share to me a link on how to...
I would like to learn how to transfer a database from machine A to machine B on MSSQL 2000. I remember seeing files for the databases. I think the...
UPDATE: This post is incorrect. Please use my third post as my starting post. I can't delete this post, I'm not sure why. I would like to include...
Good evening folks, I would like to backup all the dts packages I have created. I do it by opening it one at a time and saving it as a DTS structure...
Is it possible to add a header record which contains the total count of table and put it on top of the report and just using SELECT statement? If so,...
We have a column field that contains more than 1000 characters. The vendor asked us to export the data as text file, pipe delimeted. However, they...
I created a DTS package and I didn't put error checking. I assumed that the vendor's input file will always be correct. Last week, they changed their...
I'm very new to SSIS and have been trying hard to learn it by following some tutorials I found on the web. I need some help with my first exercise....
Hi folks, I would to learn how to write SSIS package. However, I found out today just this evening that my rights on our DEVELOPMENT box is...
Hi folk, I would like to make a stored procedure for truncating tables. However, I would like to add the table name as one of the parameters. How do...
<p> It's my first time to use SQL Server (SQLEXPRESS) on my XP desktop machine. Looking at the programs, looks like it is from Microsoft SQL...
Hi folks, I really need the DTS package I wrote to be executed by a specific local Windows account that I created. Can someone please give me...
Separate names with a comma.
