Raghavender (9/14/2011)

---

I think below will give the expected result:

-- Create Temporary table to store the data

Create Table #SQLInstances

( Value nvarchar(100),

InstanceName nvarchar(100),

Data nvarchar(100))

-- Read Data from Registery

Insert into #SQLInstances

EXECUTE...

I think below will give the expected result:

-- Create Temporary table to store the data

Create Table #SQLInstances

( Value nvarchar(100),

InstanceName nvarchar(100),

Data nvarchar(100))

-- Read Data from Registery

Insert into #SQLInstances

EXECUTE xp_regread

...

We are using 'sa' to login into the SQL Server.

Suresh B. (9/8/2011)

---

It is returning 0 rows?

It is a database level trigger. It is common for all the tables. Not just related to that table.

You can check using SSMS UI...

If I run above script its showing no triggers related to that table.

🙁

I have checked that but no triggers are there.

There is no triggers on that table.

Have a look into below url which will give you detailed information of SQL Server 2005 Architecture:

http://msdn.microsoft.com/en-us/library/ms191135%28v=SQL.90%29.aspx

Thanks Gila!!!

DHeath (6/17/2011)

---

Yes ... as you can pretty much attach and detach all MDF and LDf files within MSSQL especially withing the same version. Edition is not much of a...

That link is for whole Instance downgrade....

I need only for one database.

Yes, transaction file means transaction log file.

Is WLF will come into the picture here ?

Yes, transaction file means transaction log file.

Is WLF will come into the picture here ?

and one more question:

For eg: if we have 5 cpus in our server, suggested tempdb files will be 5, is it minimum or maximum ?

In between, this is other question on TempDB only:

If we add multiple datafiles to tempdb database we need to keep all datafiles of same size.

Can any body tell me what...