Yep, Theres no straight method. But checking whether any smart ideas.

Thanks

CREATE TABLE TABLE2(

Col1 int

,Col2 int)

INSERT INTO table2 VALUES(1,3)

INSERT...

Thanks,

object_schema_name() is useful in this context.

It may be worth noting that if the table is owned by a user (like user_schema_name.table_name), then we need to specify it as it is...

Hi all,

Thanks for all your responses,

The issue was not with the orphaned value in the system table or any adhoc updates to the system table.

The issue was that there...

I cannot DROP the PK due to this orphaned FK value in sys.foreign_key_columns.

Is there any method to overcome this? Like delet this entry?

I beleive as there is an orphaned entry in the sys.foreign_key_columns table, which prevent the DROP of PK.

Is there any method to overcome this?

Thanks Sudeepta,

Actually I was looking for a straight forward TSQL method or SSIS task to pick the SQL logins for particular databases and trasfer to another database.

I believe if the...

Hi ,

If the SQL logins mapped to a Database X, then corresponding dabtase users will be created.

But if the SQL Logins mapped to this database X has the 'DEAFAULT_DATABASE'...

Thanks for responding.

But I believe the above two methods are for transfering all the SQL Logins in the SQL server to another server.

I'm going to transfer a database x from...

Thansk for the reply.

I have figured out the issue. I kept a management studio query window open before the restart in single user mode.

Even if we start the instance...

Hi,

Sorry for the confusion.

My question would be like below:

We have the following configuratuion types in SSIS for configuring the Package Configuration:

1. XML Configuration.

2. Environment Varable

3. Registry Entry

4. Parent Package variable.

5....

Hi,

I will give my try.

1.) The easiest way to find the full details of data file usage is:

Right click database> reports> Standard reports> Disk Usage

OR use the below:

Current Database

Select name...

Hi,

Thanks

I have created 2 windows users, WinLogin1 and WinLogin2.

I have added the WinLogin1 to Local Adminidtratros group.

Added both windows users to SQL Server.

Mapped the WinLogin1 to 'sysadmin' role.

Mapped the WinLogin2...

Hi,

Thanks for responding.

I have tried with windows login. But still gets the belowerror message.

Message

Non-SysAdmins have been denied permission to run DTS Execution job steps without a proxy account. ...

Thanks.

Really what I wanted.