Most features work just fine since are bound to client as feature not server. Some things may not but most of those are in EM and are hidden when you...

Do like so in your SP

if (select count(*) from tblname) != 0

begin

--do your xml stuff here

end

Remember the CALs are per seat not per server. You have to buy a server license (not processor) for each SQL install, but each computer (or seat) is a CAL,...

First, I have been told there are things you can still do in SQL 7 that will not work in 6.5 that the compatibility mode doesn't handle.

Also, MSDN no longer...

FOr certification and some of the basic learning I like the ExamPrep books.

There are a few ways they can disappear but let's start with the simplest possibility. They may have been unreged from server some how.

Open up a command prompt and...

If you are using SQL 7 then check out this script.

http://www.sqlservercentral.com/scripts/contributions/158.asp

You will have to fix the time offsets which are noted from 4 and 5 to what yours are (I...

That question has popped up before in this group. http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=9129&FORUM_ID=5&CAT_ID=1&Topic_Title=Maintenance%20on%20system%20tables&Forum_Title=Administration

I am pretty sure there was another spot but as of yet I still haven't found a way.

Add them to the startup items in server properties individually

-T1204

-T257

Even if you added a bad line though it should ignore (unless you stumble onto something undocumented). But by any case...

If the SP is not using Dynamic SQL then yes you can GRANT EXECUTE on SP to Person/Role. The only stipulation you may have issues with is that both the...

Besides if you copyright your code and can prove they stole the code (not the concept) from you then you have legal grounds to get a nice chunk of change...

Thanks for testing the examples. I just breifly scanned. This of course has been the only real documentation on the MS site about UDFs. Otherwise it is still lacking and...

I have not but specifically what were the queries?

He should not have been able to see query 1's results set in place of running query 2 unless maybe there was...

I do hope you made a backup.

I did check I still have not had issues so I am wondering what specifically is under the hood that causes this. Can you...

Well, found last night something I forgot I had. I haven't had time to read thru it yet but I found the UDF whitepaper doc that I downloaded from the...