My bad.

Hi ratheesh,

If the user wants to run the SSIS package in the sever, you can use the concept of Credential and Proxy account available in SQL Server.

Please refer the...

Hi,

I have a doubt regarding the final article ('How to Schedule and Run a SSIS Package job') mentioned in this article.

Why do we need to give sysadmin server role to...

I found the below in BOL in IDENTITY section where a variable is declared as column_type:

-- Here is the generic syntax for finding identity value gaps in data.

-- The illustrative...

can you try to divide the transaction into many small transactions

Thanks

Its an advantage that it shows cpu_time and memory_usage of the connected sessions.

Its easy to narrow down few issues.

Cheers

Hi,

Please find the below links. You can fidn further links which will cover most the topics that you need before installing.

PS: This article is for SQL Server 2005 SP3

Whats an external certificate. Is it something that we create?

As in the below link:

http://msdn.microsoft.com/en-us/library/ms187798(SQL.90).aspx

Thanks for responding

Hi,

The most important are Sev.17,19,21 through 25

Thanks

Or the 'denylogin' field in sys.syslogins

Yes, it fulfills almost.

But my aim here is to get the 'hasaccess' field which is in sys.syslogins.

I could not find this field by joining a SQL 2005 sec. views

-- System objects to find the Database file sizes

select sum(size)*8 from adventureworks.sys.database_files -- Gives current physical size correctly

select sum(size)*8 from adventureworks.sys.sysfiles -- Gives current physical size correctly

sp_databases --...

Space constraint is the reason. Because the the extend at which the log file grows for few databases is undesirable eventhough we have space.

I believe when it is set...

Hi,

What about the recovery with BULK LOGGED transaction log backups. Does switching the recovery between BULK and FULL break the LSN chain?

Cheers

Hi,

Thanks for the reply.

Yes I take FULL & log backups.

I believe this is due to the huge REBUILING happening during the index maintenance. I thought of different mechanisms to...