'Linked Servers' have security as well.

(Right click on the linked server in EM, and choose the security tab)

Is this setup that only admins can use the linked server?

I played around with the database, prior to scheduling another restoring of different days backup tonight (that hopefully that will be okay). There were lots of errors on lots of...

If you want to create users in the database, you may be able to use the sp_addalias stored procedure to alias an account to dbo.

Beware is right, but as long as it is known to the developers etc I have found it isn't too much of a problem.

I have had to mix collations on...

You can add a constraint to a table variable

(which is the same as an index under the hood)

You can just remove the whole file, hence have no noise words

If your DBA allows it, you can call xp_sendmail to send the email, but access will need to be granted for that xp to any user that inserts into the...

Better add to the first point (as it doesn't read to well)

If the users have access to multiple databases on the same server, and the initial database is offline (dbo...

I personally set the default database to the primary database that account uses (or the first one they get setup against) as I don't like seeing user accounts in the...

Remember the 8K page limit per row.

Hence if you use unicode you half the amount of data you can hold in a row.

In addition to Andy's comment about FTP.

If FTP is not available you can manualy copy the snapshot directory local to your server

to initialise the snapshot, but this does make reintializing...

Using 8i , went for the oracle one because we are running oracle stored procedures.

If you do manage to break it, update the thread.

Steven

Thanks anyway.

I had already concluded all I could do was keep an eye on it, hence the question about moniting it.

I have to have the hotfix installed or the CRM...

I have the post sp2 hotfix Q314003 installed on that server.

Happened lots of times over an hour, then its was okay. That server does run lots of DTS jobs using...

If you change the 'minimum query setting' remember it is KB not bytes.

I have in the past found it set far too high which sort of killed the server.

...