hi tswg2002. There's nothing wrong with identity column. I use it more often than composites because it makes joins easy. My rule is, if the primary key is referenced by...

sreeni, thanks. I tried installing it again this time using NT authentication. Still no luck; same message, same result. I was installing it in SQL2k Ent Ed with SP2.

Edited by...

Hi guys. I totally envy you 'cuz you're already running sp3 while I can't even update to SP3 due to some errors.

I have SQL2k enterprise in my .NET Server 2003...

That is alsp my hunch but I just want to make sure. I think I have to do a little Winsk server digging myself. I am just curious.

Tahnk you...

I tried it and still no luck. Changing the properties in the server registration did not grant non-admin NT user right to use EM. What I want is to allow...

hi guys....

SQL Server error generation and handling is very inconsistent and unpredictable. "IF @@ERROR..." construct is not a guarantee that you will trap the error because some errors cut the...

Thank you so much guys!

Actually, I didn't know there's such a statement. I have lots of sql books and none of them ever mentions such statement. Maybe because it's a bad, bad one.

Anyways, thanks...

I removed any error handling routines and still no error reported.

That's exactly my problem. SQL Server does not report the error to VB at all.

Antares686, thank you very much.

I GOT IT!!!

I just forgot to assign value to SQLRestore.Action (see my snippet).

bmsjr,Warren, thanks very much!

bmsjr, if you don't mind sir, can you post a vb-dmo code snippet of yours for backing up and restoring database. I just want to learn from experienced DBA's like...

Andy, I cannot formulate the exact select statement for fetching the logins of a database together with the roles where they belong using sysusers table. Is it possible to do...

Great article. This should have came out before I wrote my first SQLDMO app. I remembered I was having a hard time with that using only the Object Browser and...

quote:

---

Did they give a reason why (for not using Hungarian)?

---

Hi Warren. According to MS,...