"But now I cannot connect with my web pages. I have so much SQL written into my VBScript code, I dont know if it is good with SQL Server or...

" have not been able to preserve the Primary and Foreign Key relationships between the tables in the Target Access Database."

Are you referring to items like auto numbers, etc... This can...

Personally I prefer DTSBackup2000 http://www.sqldts.com/default.aspx?242

But, like everything with SQL there are many ways. Try this for transferring directly from the table http://www.sqldts.com/default.aspx?204

Always be aware that if the package...

Rudy, That's probably what I'm thinking of then.

Homebrew01, Honestly, I wouldn't run this at all. There are plenty of easier ways to get this information is a much more "usable"...

First one for sushila...

First, God created man. Then he had a better idea

A couple from Monty Python, always a source of enjoyment

"And now for something completely different..."

"I don't wanna talk...

Actually, if the guys didn't run such a good site we wouldn't be here in the first place.

So I guess the onus is back on them

Yes you can query the system tables, but I was talking about a single command.

It might have been in an earlier version of SQL Server. It showed the basic...

So will this be a CMS type system along the lines of http://www.dotnetnuke.com, or an application/code generation tool along the lines of CodeSmith, ASPRunner.Net, ASPMaker.Net, etc...

So just take the field out of the select, or concatenate it with the name, or use a case, or ...

You can achieve this using a derived table.

select 
    t1.id
    , t1.name
    , t2.childcount
from mytable as t1 
  left join ( 
        select 
            parentid as id
            ,...

Save yourself the problems of working out what is compatible with what and worrying about MS Exchange connectivity and security.

Install xp_smtp_sendmail from http://www.sqldev.net there are versions of the DLL...

Ok, first thing you need to do is get rid of the cursor. If you take a set based approach you'll find your performance will increase dramatically. Now as this...

Sorry, I help people reach their goals, I don't do their work for them.

If you can't take the information I've provided and re-build your query, I'm not going to do it...

"what do u mean about seriousness.

Do this is the way u ask a person who need help?"

Given your history, under this and other usernames on this forum, yes this is...

Use this bit to get the results without using a cursor. Replace <<mydb>> with a database that exists on your server.

if not exists (select * from dbo.sysobjects where id...