Could you please guide me with this verfication process. All configuration settings seem correct to me.

Thanks for your suggestion. Even i had the same concern about shrinking of the files. If possible, can you let us know in which scenario the log file can grow...

So,i can establish foreign key relationship with column in the primary table(whether the same table or different table).

Thats right i was trying to insert value in table1 from the values...

i am entering a non-null values, which are present in either of the two primary tables

Local to the server!!!

yes, i even tried doing that!!!

Its a local drive!!!

I am running this on my local system and the file do exists in the path specified.Also, i can run this command through command prompt.

I tried giving the complete path

exec master..xp_cmdshell 'call E:\PROGRA~1\CA\SERVIC~\bin\bop_cmd.exe'

and i got following error: "The system cannot find the specified path"; but the file do exists

I need to understand if...

Hi,

I am using a xp_cmdshell method of running command and i used the following tsql statement

exec xp_cmdshell 'bop_cmd'

but it gives following error

'bop_cmd' is not recognized as an...

Thanks a lot Mark!!!

This information gave more confidence to me 🙂

You can prevent connecting to the server through window authentication without deleting the BUILTIN\Administrators account.

This can be done in two steps:

1 Step: Remove the sysadmin server roles for the...

Also, the regional setting should be English(United States)

Thanks a Lot,

Its a default setting with definition:- dictionary order, case-insensitive for use with 1252(English) Character Set

Thanks again

Thanks, exactly what i needed!!! thank a lot