Hello Jim,

If you are restoring the database from Enterprise Manager (GUI), then you can Right Mouse click on Databases and select 'Restore'. You will be prompted with a screen showing...

Hello Eamon,

You can check the current status through Enterprise Manager (Your server -> Management -> Current Activity -> Process Info).

It will show the details of the SPID (Process ID), Database,...

Hello Phil,

Has the password for the user with which it is getting executed changed? Try to refresh the data sources on the SSIS package.

Hope this helps.

Thanks

Hello Craig,

Can you try this logic to test?

declare @num real

set @num = -10

select cast(replace(convert(varchar, @num), '-', '') as int)

you can substitue your column name for @num local variable. if your...

Hello Mc,

In order to turn off transactional logging, you need to change the recovery model to "Simple" and not "Bulk Logged".

Go through this link and you will find the details...

Hello,

In order to change the service account passwords, you need to be a local admin on the box and then go to Administrative Tools -> Services and then change the passwords...

Hello Dave,

Possible reasons for Tempdb getting filled might be

1. Temporary objects being created and not dropped at all.

2. Lots of DML operations carried on without transaction handling.

Hope this might give...

Hello,

The algorithm being used by LiteSpeed is different from the standard zip / rar format. You need to install the LiteSpeed per system even thought it might have number of...

Hello Mario,

You can check these new set of tables to get the information. Please go through 2005 help on this link

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

Hope it gives you the required information.

Thanks

Hello Ramesh,

By default, in SQL Server 2005, a table is defaulted to the "dbo" schema. You can select the results without the "dbo" prefix from the queries as usual.

By the...

Hello,

Have you checked whether you have the exclusive "execute" permissions on the stored procedure? Execute permissions default to "sysadmin" fixed server role.

Also try to execute the single statement for deleting...

Hello,

You can change the installation location by clicking on "Browse" button. It will show you whether you want to calculate the "disk cost" and on above you can find the...

Hello Jade,

The reason for that error is that you have not added any linked server required. Please look in to Books Online of SQL Server for "OPENQUERY". Otherwise, if you...

Hello,

Yes, Table and Index partitioning are only supported on Enterprise & Developer editions of SQL Server 2005.

Thanks

Hello Ryan,

Please try this one

declare @<your local variable> smallint

set @<your local variable> = 3

select <your table name alias>..name as Child, <your table name alias1>.name as GrandChild

from <you table name> alias...