I have limited knowledge on them so wanted to know more. Nothing else.

nicholasr 68909 (11/9/2011)

---

I might be misunderstanding something but when setting ANSI_DEFAULTS to on I would be also setting implicit transactions on which from what I am reading here is a...

Off the topic, but I was searching for MVPs around the World and found 280 MVPs for SQL Server.

https://mvp.support.microsoft.com/communities/mvp.aspx?adv=1&name=&competency=SQL+Server&discipline=&certifications=&country=&state=&city=

I noticed you (Gail) in the list. May I know who else...

What are you trying to do?

GilaMonster (11/9/2011)

---

p.s.

Dev @ +91 973 913 6683 (11/9/2011)

---

obetween 5% and 30% logical fragmentation, reorganize it (using DBCC INDEXDEFRAG or ALTER INDEX ... REORGANIZE)

omore than 30% logical fragmentation, rebuild it (using...

He doesn't need to be an MCM to prove his mastery on the subject. He has it & he has proved it long back and...

Chinese (Macao SAR)

Chinese_Traditional_Pinyin_100_

Chinese (Macau)

Chinese_Traditional_Stroke_Order_100_

Chinese (Singapore)

Chinese_Simplified_Stroke_Order_100_

Windows Collation Name (Transact-SQL)

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

Gail, the article is really educating but what’s the probability when Paul would say “It Depends”.

In most of the cases we can follow it as Rule of Thumb.

•if an index...

select one,two

FROM OpenDataSource( 'Microsoft.ACE.OLEDB.12.0','Data Source=C:\Excel\test.xlsx;Extended properties="Excel 12.0;HDR=yes;IMEX=1";')...Sheet1$

The Error:

OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)" returned message "Unspecified error".

Msg 7303, Level 16, State 1, Line 1

Cannot initialize the data source...

Similar Issue and RESTART option rocks 😀

http://www.sqlservercentral.com/Forums/Topic9165-5-1.aspx

The main purpose is if I have made any change to the field(such as change the name of field) , i need to update all the places in the database...

Also sys.dm_exec_sessions (Transact-SQL)

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

Are you running it with some other client utility? or other connections (say ODBC) from application? Then find the session &...

insert into dbfile values('A01',getdate()-2,getdate()-2,'Week-Wednesday-0-1-0-1-0','Export Database','*')

As I have already mentioned I am against Spoon Feeding so I am letting you design the table. However few recommendations based on insert statements above:

A01...

Stop it with SSMS, if it's in SSMS.