What I meant was that if I am using the management studio to connect to multiple databases, how can I find that out from the explorer window.

cool. thx guys.

Don't think so. I looked at it. It doesn't do the job. I have asked them if they have something similar to Dependency Tracker for Visual Studio.

Works great. Thx.

BTW, Is something similar available for Visual Studio? Say I want to modify a DLL. But before I do that, I want to find out where...

I have SS 2005.

Thx. It works for a single key. But not for a composite key. If I have City and Zip in Client and in State, and I try:

SELECT *

FROM Client

WHERE StateCode...

I am trying to create a table and copy data from a different database to tempdb.

use tempdb

CREATE TABLE old_client_table

AS (SELECT * FROM WarmSpringPRD.person)

What am I doing wrong?

Thanks a ton Shri

I've created a full bkp that backs up to a file on the disk. The file then gets picked by the daily backup job. If I want to automate the...

it's in mm/dd/yyyy format

but what if i am not using any statements and using the import/export wizard?

Thanks a million.

When you say, all services should be stopped, SQL Switch should do it right? Can you please clarify what you mean by blowing away the tree?

This worked:

set ANSI_NULLS ON

set QUOTED_IDENTIFIER ON

go

ALTER PROCEDURE [dbo].[lu_Ethnicity_Insert_One]

(

@nvcEthnicity nvarchar(30),

@nvcASCU nvarchar(256)

)

AS

SET NOCOUNT OFF;

DECLARE @intDspSeqNbr int

SET @intDspSeqNbr = (select (max(intDspSeqNbr) + 100) from lu_Ethnicity)

SELECT @intDspSeqNbr

INSERT INTO lu_Ethnicity(nvcEthnicity, intDspSeqNbr, dtASCD, nvcASCU)

VALUES(@nvcEthnicity, @intDspSeqNbr, getdate(),...

This is what I followed and it worked:

http://blogs.msdn.com/astebner/archive/2005/09/13/465401.aspx