When I checked the instance property ,it is (2,147,483,647 kb),which I guess is default one,because nobody has not changed it.So should I apply any changes on this memory setting.

As I said,When I run DBCC CheckDB 'Order',exec AdminDBReindex 'Order' instead of those dynamic code,I do not

recieve an error message.but When I run the job I recieve error message.Also...

Thanks a lot for your reply.but here is the job that I was running and I was facing with problem.

Instead of this job when I run

DBCC CheckDB 'Order'

exec AdminDBReindex 'Order'

(Which...

Here is Example,

For Instance I am trying to run the following statment:

2627:Error Code for primary violation

raiserror(2627,16,1)

the result of running this statment:

Msg 2732, Level 16, State 1, Line 1

Error number 2627...

Thanks a lot for your reply.But,I just was wondering if I can re-produce primary key violation in Second(SP2) by using Raiserror.It seems that RaiseError does not have any explicit ...

Thanks for your reply.

you mean ,I can not use it in any combination.For instance,If I put Publisher and distributor in SLQ SERVER 2008 and Subscriber in SQL SERVER 2000,Does this...

Actually,The Database that we are using in Log shipping ,it includes only SQL SERVER 2000 data types, and we do not have any problem with that.Just is it possible to...

Actually This is Request,that I have recieved from managment.

No as I said ,Theere is not any problem with SQL SERVER nrework protocol

In SQL SERVER Log,I have "SQL server listening on TCP, Shared Memory, Named Pipes." and on the...

I tried both(Window and SQL authentication),but in both cases it failed.Yes it is porduction.As I said nothing has chnaged in thios sevrer.All the connectivity issues started to happen when I...

Thanks a lot for your reply.

Do You mean just sending the trasnasction logs that has been caused during the maintainance jobs?

Thanks for your reply,Can I combine it with normal TSQL?

Which roles should I assign to that user?

Thx,But How can I give the right of access to "Integration Service" to an windows account

I know,My question is related to Managment studio environment.Now,how can I give the right of access to "Integration Service" to an windows account.Actually this will solve my problem.

Thanks