Does anyone know what datatype in SSIS is equal to SQL Servers smallmoney? I have a sql task and I'm trying to put my result set (a smallmoney SQL...
Can someone tell me what my have caused this to happen? If I run the query below in one of my databases I get 67 rows returned and there should only...
Can someone tell me what components are installed with SQL Server Analysis Services in SQL Server 2005? I'm trying to make sure that our admin...
I have a data modeling question and I didn't know where to go for help and everyone on this site is so helpful that I thought I had to try here. I...
I'm trying to create an SSIS package that will drop a table if it exists on server B(destination), then copy the table from server A(source) to...
I moved some jobs to a new instance of SQL Server 2000. I ran the jobs last night and several failed. In the first job, the first three steps ran...
Can someone tell me how to reclaim the unused space in a database? I have all ready run DBCC Shrinkfile and DBCC Shrinkdatabase with truncateonly....
I'm running a restore to restore a database. I have to restore the database and then DTS the tables I need to an existing database. Is it possible...
What is the difference between an incremental and differential backup? I have found information about the differential in BOL, but not the...
What is the difference between restore and recover? Andy
Does renaming a database change any of the underlying objects (tables, views, stored procedures)? Andy
Can someone tell me where or how to find information on transaction log size? I am trying to create a job that will send me an alert if my...
I'm still very new to SQL Server and I am going to be setting up a brand new server to run SQL Server 2000. Can someone tell me if there are any...
I'm new to SQL Server, but I need to find the following information and be able to recreate it weekly for database load reports. Can someone tell me...
I need to drop an index that SQL Server 2000 says does not exist in the system catalog. However, when I try to create the index I can't becuase it...
Our server is Windows 2003 SP1, 4 X 2.7 GHz Intel Xeon Processors, 16 GB SDRAM, Hard drive 4 X 72 GB 15K SCSI, and SCSI HP Smart Array 6400...
Does anyone know what normal or reasonable values for Network Reads, Network Writes, Network Bytes Read, and Network Bytes Written are? My values to...
I have access to performance monitor, but I can't seem to find some of the performance objects. I have PhysicalDisk, Processor, System, etc... but I...
I have used bcp and bulk insert to load my table. They both work, however, they only load half of the data. If I use DTS all of the data is loaded....
Separate names with a comma.
