Hi i know this answer it was syntax wrong but i put 1 as wrong anwer.

because i thought that there may wrong with script.I know that this script will give...

CirquedeSQLeil (6/9/2010)

---

malleswarareddy_m (6/9/2010)

---

I put it newreadonly but still it allows to create a table. which is not possible with setting with tool. (database properties----readonly---true.)

then create new db with wizard. It...

I put it newreadonly but still it allows to create a table. which is not possible with setting with tool. (database properties----readonly---true.)

then create new db with wizard. It automatically creates...

hi without the script i set the model database into read only.then i create the new database but i am not able to create the new table because it is...

I got wrong.Thought that it will give error the sp_ ...... procedure already exists if the procedure name alreay in master database.

I got wrong.First I checked for hours and then i thought 7.and guess that with additon of minutes into hours ,answer is 8. and i did not checked minutes.start minutes...

this may be worked.i checked for my database.Please suggest me if it is wrong.

select

case when index_id=1 then 'Clustered'

else 'Non-Clustered' end as [Index Column],

T.name as [Table name],C.name as [ColumnName]

from...

This query will give the result

select i.name as [Index],i.type_desc as [Index type],T.name as [Table name],C.name as [ColumnName]

from sys.tables T inner join sys.columns C on C.object_id=T.object_id

inner join sys.indexes i on...

UMG Developer (6/1/2010)

---

malleswarareddy_m (6/1/2010)

---

UMG Developer (6/1/2010)

---

Wow, I happened to be the first to answer it, and I got it right. 🙂

Though not for the reason you stated, as it makes...

UMG Developer (6/1/2010)

---

Wow, I happened to be the first to answer it, and I got it right. 🙂

Though not for the reason you stated, as it makes no difference if...

good question.Excellent explanation.

USE master

GO

-- To use named parameters:

EXEC sp_addlinkedserver

@server = 'SF-PC035',

@srvproduct = '',

@provider = 'SQLNCLI',

@provstr = 'DRIVER={SQL Server};SERVER=SF-PC035\sqlexpress;userid=sa;password="password";'

EXEC sp_addlinkedsrvlogin 'SF-PC035', 'false', NULL, 'sa', 'password'

sp_addlinkedserver is for creating...

Today i learned new topic about VLF.

I did not understand this question.in question it shows that to select wrong sytax.but all resturns table data without any error.then i did not found the wrong answer.so i applied...

good question.

when SET IMPLICIT_TRANSACTIONS off it will shows two times and other wise if we put SET IMPLICIT_TRANSACTIONS on then second time it shows "invalid object".This is due to SET...