Yes, I agree this a custom message, and not the SQL Engine.

Hi Guys, Steve,

We have a similar setup, but we also have changed the registry to allow sqlserver to record 7 log entries, so that we also have the last weeks...

You may want to check the Active Directory (if you are using it) as I have found that simply renaming a server isnt the end of the issue, as AD...

h

I tend to reserve the use of nulls for things that havent been asnwered at all, rather than for an unknown, as technically when a user answers unknown, she/he is...

this is all very true, but I have run into this problem quite often with various clients, where the scope of the table or field is set in stone at...

hiya, thanks for that.

i didnt explain my question very well, (infact my explanation was attrocious).

I want to be able to determine what order I need to insert the table in...

so...

yes, or compile them as a DLL in VB and use them in .NET once you have given them a RCW - I have written a C# class that will...

exec master..xp_fixeddrives

 -- Alex

Usually, when I migrate from 7 to 2000, I have found the easiest way is to detach the database from v7 using sp_detach_db, copy the MDF (and the log if...

alternatively if you want to check for more than 1 value. You could use a CASE statement. Check BOL for the correct syntax.

 -- Alex

 ... dont listen on the default port.

I beleive you can 'hide' what port SQL Server listens on, which infact just alter the default port.

 -- Alex

Hi, I'll give you some info on how I last achieved this for a recruitment company here in London. (I'm not sure if another post has already included this information...

Cheers for that Greg.

What if ourdata analyst, administrator or even CEO were to want read access to data, and hence every object.

Is the db_datareader still a bad option?

 -- alex

hi all, can someone inform me of all the drawbacks of using db_datareader, db_datawriter, etc.

thanks,

Alex