Hi,

Please help me to understand your lines "A being the primary key, B unique key. I am creating clustered index on A,B." Please send the complete Script of Table.

To answer...

USE <DatabaseName>

Go

CREATE TABLE EmpTable

(Poistion Varchar(50), Name Varchar(50))

GO

INSERT EmpTable

VALUES ('Manager', 'Scott')

INSERT EmpTable

VALUES('manager', 'Jhon')

INSERT EmpTable

VALUES('Manager','adam')

INSERT EmpTable

VALUES('Accountant','marry')

INSERT EmpTable

VALUES('Accountant','zee')

GO

-- Funcation

CREATE FUNCTION [dbo].[fn_ReturnName]

(@Poistion Varchar(50))

RETURNS VARCHAR(MAX)

AS

BEGIN

DECLARE @Name VARCHAR(MAX)

SELECT @Name =...

In SSMS the same T-SQL taking around 1 Hour to complete the all 2000 databases backup and once first database backup completed it disply the result BACKUP DATABASE successfully processed...

Ok!

What I understand that when SQL Agent Job Executes the T-SQL then the cursor issues the cmds "BACKUP DATABASE <dbNam> ...” for all databases and cursor loop do not wait...

Hi,

Actually I would like to consolidate/merge two instances of SSRS into one instance of SSRS.

What will be the best way to merge two Instances of SSRS? How I will migrate...

Hi,

I got the answer, Only changes will come from principal to mirror. Trigger will not fire and also xp_cmdshell will not run on mirror database.

Hi All,

I find out the solution and root cause it.

Please find the solution as attachment.

I would like to know about you (Gail Shaw) , you profile, your experience and roll on http://www.sqlservercentrle.com

You always try to answer every question – Is it ok?

:w00t:

I am also facing the same issue.

I have SQL Server 2005 RTM and 10 databases are there. My Full Backup and Diff backup is working fine but in a database...

Hi,

I have this on production server.

windows account policies are good if I'm going to create new login.

My problem is that I want to find out thoses login who should...

Hi;

Is no one to solve this thread.

Yaa !

There two System Views

1. sys.Server_Principals for Logins (saved in master database)

2. sys.Database_Principals for Users (saved in each user database)

Yaa you are right but my concern is that

Why Microsoft say that "Check the backup application log for detailed messages." What it mean? Where the details? Is Microsoft pointing...

Hi;

Please pass required parameters

http://msdn.microsoft.com/en-us/library/ms190737.aspx

Hi;

You can't but u can generate script of all objects per database and then export data.

otherwise no chance!