What is the Data Source query look like? Is it a simple or complex query with a lot of joins? Try running it in SQL Server Mgmt Studio to see...

Can you post the exact message (without sensitive info) from the SQL Server logs? Just one set.

Did you check if the PHP pages have code that is trying to...

Hello Ifila,

To reset the SQL Server administrator password, you can login using a windows account belonging to the local administrators group on the windows machine where SQL server is installed....

Attached is a screen shot. You can see the setting in the properties of SQL Server instance. You can get to this dialog by right clicking SQL Server instance in...

Can you check the Job history details? It may be the user context that the job is running under that may be cuasing the issue.

In SQL Server 2005 there are 2 options "Enforce password policy" and "Enforce password expiration". These 2 options are specific to SQL Server accounts. these options are just yes/no. properties...

if you need a stand by server, replication may not be the best option. it has some requirements. here is article that you may want to read first.

http://www.sqlservercentral.com/articles/Replication/logshippingvsreplication/1399/

You can definitely setup different backup locations for different databases. if you are using a maintenance plan to backup the databases, you can setup multiple maintenance plans. If the jobs...

here is some info on statistics maintenance. this should answer your question. statistics are only updated when a certain threshold or percent of updates of occured to the data. if...

Hi there,

Are you trying to connect to one instance of SSIS?

you may want to read on how to configure SSIS.

http://msdn2.microsoft.com/en-us/library/ms137789.aspx.

Hope this helps.

a

Try this

exec master..xp_cmdshell 'dtsrun /fc:\dbtest\3RefExp1911.dts /n3RefExp1911'

instead of the syntax you have used and see if it works.

Also, you can check if the destination date column is set to NOT NULL. So if there is a null value coming from the Access date column then you could...

Another way to achieve what you are doing is to create a 3rd DTS package and in the new package create tasks that execute the other two packages.

The task type...

one more thing. I believe the Explicit transaction should take precedence over the TRUNCATE statement.

If you issue the Truncate statment on its own you won't be able to retrieve the...