Hi Shashank,

To check T-SQL command syntax next time use google.com , I hope this link will be useful:

DBCC SHRINKDATABASE syntax

Max

Hi

The garbled mess is Unicode output from xp_sendmail. To change output coding to Ansi try to set xp_sendmail parameter

@ansi_attachment = 'true'

This link from MS KB should...

Hi Mitch,

Maybe this will help

http://www.experts-exchange.com/Databases/Q_20756875.html

Try changing setup parameters

Hi

I would merge "Claimant Info" & "Specific instructions" because they are connected only with Claim Case.

Max

Note: I have no UNIQUE field in it so no field is indexed ..

Not every index...

u don't need SQL login, put NULL instead of 'sa' and then all SQL Server logins will have access to linked server.

Go to Enterprise Manager,select properties for added linked...

'Admin' login probably doesn't exist on your SQL server. Try replacing 'Admin'->'sa' or with any login from SQL Server.

Read again BOL docs about sp_addlinkedsrvlogin.

Max

In this case 'admin' is a remote login and last parameter is remote password.

Setting null for 3rd parameter:

"NULL specifies that this entry applies to all local...

if u check sp_addlinkedsrvlogin syntax then u will see that your parameter 'admin' should be a SQL Server login or a Windows NT user and Windows NT user must...

U can try to start transaction on client,than run each SP from client,and finally commit transaction on client or rollback if sth will go wrong.

If u r using .NET this...

ASP.NET process is running in certain user/system account context (in W2k3 it will be NETWORK SERVICE account, in W2k and XP it going to be ASPNET user).

See more about...

Check syntax on MSDN site:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_create_64l4.asp

More about indexes, see 'Lesson 3: Creating Indexes':

http://www.microsoft.com/technet/prodtechnol/sql/70/books/c0618260.mspx

Before asking this kind of questions, use google instead.

(e.g. 'MSDN create index ')

Regrads

Max

I read the article, but didn't get the idea to research.

If you could be more clear.

Thx

Max

I was looking for sth similar to ( TSQLUnit)

or (SQLUnit ) but test written in C#.NET or VB.NET.

Regards

Max

Hi,

Select * from T1 WHERE id = 100

UNION ALL

Select * from T1 WHERE id 100 order By NewID()

I hope this will be useful

Max