Haven't used OO dbs. Heard good things about them, but they appear to be a niche. Maybe because of complexity, maybe because IBM/Oracle/MS don't push them. Don't know. CA has...

MyConn = "driver=SQL Server;server=x.y.z.a;database=mydb;userid=me;pwd=test"

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

I wrote some information on this in http://www.sqlservercentral.com/columnists/sjones/vcspart1.asp. You need to get people in the habit of "checking" out the files and then editing them from the file, not the...

Not sure what you mean about doing the update.

If there are duplicate title and artists, are you trying to get the trackid values in the child table set to the...

Is this SQL Server 2000? If so, the restoring to other servers isn't a big deal. Can always attach files from whatever drive they are on.

As far as performance. From...

<shamelessplug> Brian's Admin 911 book is a good beginner place to learn about admin'ing SQL Server.

</shamelessplug>

For designing tables, it works similar to Access, though I'd grab any of the "application"...

Not really appropriate for the the suggestions forum. This is more of a Development issue.

Pls post there.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

Not to play devil's advocate, becuase I get as annoyed as anyone with subject lines that don't pertain to the message. Same with cross posts.

However, the have been times that...

Use a maintenance plan.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

And you didn't have to tape anyone's eyes, did you .

Congrats and thanks for the hard work.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

Actually more complicated, but basically when the account logs in, it gets a token with the SIDs that the user has associated to them (user + groups). These are then...

try select * from syscomments where text like '%suid%'

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

I know the statement will be recompiled, but not sure about the procedure. Will try to test.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

There sure are some beauties. Wonder how many posts wouldn't have been made if it had been more correct.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

What happens if you restart the installation

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones