Glenn Dorling (7/26/2009)

---

This is not really about whether the users connect using Windows or SQL Server authentication (although I'd support Microsoft's recommended best pracrtice in using Windows authentication only if...

Melton (7/26/2009)

---

I would not remove the local Windows group, especially Administrators (local group), from SQL Server unless you have a sysadmin account setup within SQL. If you don't you...

I believe you can remove all windows groups/logins from the server, and this would prevent any windows user from by passing the logins. Also, I too must STRONGLY advise...

I think I might start at a lower level. What media is this being stored on? Is it local disks? Are they RAID? San? ISCSI? FAS?

If...

The company that makes the SMS Gateway I was talking about is Ozeki NG.. It is at:

http://www.ozekisms.com/

CEWII

An unapproved assembly is basically an assembly that MS has not explicitly tested and stated that they believe should be referenced by a SQLCLR assembly. Most assemblies cannot be...

I stand corrected, however, that used to be true in SQL 2000. I admit I didn't re-research it, perhaps I should have..

CEWII

I think I'd start with the document that you are using for the mail merge and see if there is a setting that gets it to pickup the contents of...

the should. The LIKE operation tends to be expensive..

Also, why don't you test it an tell us..

CEWII

I have some recommendations but not a whole doc..

1. Packages are deployed into SQL Server, this allows them to be backed up with the SQL data and does not require...

Have you looked at the query plan for each. Also, was the index created after the sproc? Perhaps a recompilation of the sproc is necessary. If you...

Will the data in any specified table be updated in both locations or only on one side?

CEWII

This might help:

ADO:

http://msdn.microsoft.com/en-us/library/aa123760(EXCHG.65).aspx

Other programming tech:

http://msdn.microsoft.com/en-us/library/ms876253(EXCHG.65).aspx

CEWII

I don't think you can get the package to auto-adapt to this, you likely could manipulate the package with the object model.

CEWII

I guess I don't see a need to get around this.. Grant the user access to the MSDB database to your users and add the user to the role.

I don't...