On running dbcc checkdb, I got the below error, any ideas how to resolve this error, I need to find out the tables that have issues and should try to...
Below is my requirement, 2 tables(table1,table2) have same number of columns and same datatype. For example: Table1: empID LastName FirstName...
Please let me know. Thanks.
Here is my requirement: 1. I have a sql statement which is a source, I need to load this sql statement's output into Table1 which has 30 columns. 2....
I am planning to use either one of the following to copy the data from sql 2000 DB to sql 2008 database: 1. SSIS: to copy only the new changes over...
I want to transfer logins from sql server 2000 to sql server 2008, so far I can only see the sql scripts online for sql 2000 to sql 2005, but not to...
I have created partition on an existing table, Steps I followed are as follows: Created partition function Created partition scheme I tried to drop...
We get a csv file every 1 hour into our FTP server and then that file needs to be grabbed and then the data from that file needs to be loaded into...
Using the script task I am checking for the excel file existence and upon file existence, then using the data flow task loaded the excel data into...
In what order does the following need to run: 1. Reorganize data and index pages 2. Update stats 3. Check database integrity How often do we run DBCC...
I was checking PERFMON (SYSMON), I tried to google to read some on this, but did'nt get much from that, please advice if you can refer me to some...
This article is using xp_sendmail, if I want to use SMTP instead of xp_sendmail how I can do that? I think MS will not be supporting xp_sendmail in...
I would like to create email notifications using SMTP if the drive space is reaching certain limit, please let me know how I can do this. Thanks a...
Separate names with a comma.
