Update Statistics <> Auto UPDATE STATISTICS option

1> When i say Auto create statistics, what are the columns for which statistics are collected? A…

copy

Hi All, I want to copy a folder from one server to another using XP_CMDSHELL command.The folder con…

Sqlserver2005

Hi All, Need some help..... I have a concern with one of our production server which is running low…

SQL server starts slow

Hello, I have a windows 2000 standard server with sql server 2000, when i start the server it takes…

Problems with Execute SQL Task

I have an Execute SQL task on an Oracle database that I want to perform the following (Note:This SQ…

i have a problem while i running the below sp's I unable to fix the problem. Error Message is Must…

TDS, RPC malformed packets

Hello, we have a standard apappliactionhich uses a sql server. Till last week we used a sql server …

SQL Query Help

Can anyone help me build a sql for teh below scenario id score 1 100 2 200 3 300 4 …

How to run package with dynamic OLEDB connections from .NET

I have an SSIS package with two OLEDB connections. The package copies data from one server to anot…

SSIS Package SQL Agent Scheduling Fails.

My enviroment: DEV/TEST = XP Pro, VS 2005 and SQL 2005 (SSIS, Database) PROD = Wndows 2003 64bit / …

Error code: 0x80040E4D. An OLE DB record is available....HELP NEEDED PLS

Hello guys, i'm getting a weird error - I've 2 packages, the first one calls the other, both are pa…

Cluster Index to a New Column?

I need some direction with a db I inherited. I'm planning on making some changes to it and just wan…

Sql 2005 Named instance starts until I assign it a static port

I installed a Sql 2005 x64 default and named instance. The named instance starts when I use all def…

SQL 2000 domain level change

We are changing domain level from mixed mode to native and have sql 2000 on server 2003, what is t…

Cannot find package from variable

Please help. Posted yesterday but no answers. I have a connection string for a child package defin…