What do you need to get from the page? There are various ways you could accomplish thru various means, some of which depend on your SQL server version.

Example, I...

I am confused are you asking if the database it self can be globally uniqe??? Can you be more descriptive of your needs?

"Don't roll your eyes at me. I will...

I would disagree as well. I am both a DBA and a Programmer (Basic(VB and regular), Java, C(++), html, SQL, and Crystal Syntax). And if you look at the things...

I would say yes, I don't normlly look at CPU usage in regards to those items as I believe they may be incorrect but not sure. I see anywhere from...

The problem is you don't see happening again and it might not. I had this happen to me on at least five occasions and am looking for the root cause....

Try this.

@cmd='INSERT INTO ' + @tableName + ' (name, address, date) VALUES ''' + @name + ''',''' + @address + ''',''' + CONVERT(varchar,@date,101) + ''')'

exec(@cmd)

Notes:

First you need to make...

I agree with Andy, most likely it stored the first or last query plan generated with the SP. When it did this it now most likely doesn't try to build...

There are as addressed here various ways. Personally I would suggest Andy's as best, then you have some controll and can log specifically what they ran and save the input...

If you look at the execution plan they are the pretty much the same except BETWEEN treates '1/10/2002'

as <= where you have <. Also, it may be a fraction...

Another group here used NotesSQL and I don't remember them having too many issues getting connected.

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston...

I do believe you could still use OPENDATASOURCE, however the drivers have to be installed on the SQL Server which you connect to, not your local machine. Also, if you...

This looks like the same message from http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=6669&FORUM_ID=23&CAT_ID=2&Topic_Title=System+Resource+Exceeded&Forum_Title=General is this the same? And if not are you using a VB dll? If so can you post the code and the...

This looks like the same message from http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=6710&FORUM_ID=65&CAT_ID=1&Topic_Title=System+Resource+Exceeded&Forum_Title=Performance+Tuning is this the same? And if not are you using a VB dll? If so can you post the code and the...

I have never had to do this except once when I had a corrupt tempdb it grew. If the other suggestions do not work the stop the SQL service delete...

I have not noticed this but could be a known issue, however I keep the current SP installed and start SQL 2000 with SP1 so may have been an issue...