Viewing 15 posts - 16 through 30 (of 35 total)
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...
"The way to get things done is not to mind who gets the credit for doing them." - Benjamin Howett
March 6, 2003 at 9:40 pm
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...
"The way to get things done is not to mind who gets the credit for doing them." - Benjamin Howett
March 6, 2003 at 1:26 am
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...
"The way to get things done is not to mind who gets the credit for doing them." - Benjamin Howett
March 4, 2003 at 1:17 am
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...
"The way to get things done is not to mind who gets the credit for doing them." - Benjamin Howett
January 24, 2003 at 12:11 am
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...
"The way to get things done is not to mind who gets the credit for doing them." - Benjamin Howett
January 23, 2003 at 3:11 am
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...
"The way to get things done is not to mind who gets the credit for doing them." - Benjamin Howett
January 18, 2003 at 6:19 am
Thank you so much guys!
"The way to get things done is not to mind who gets the credit for doing them." - Benjamin Howett
November 8, 2002 at 11:46 am
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...
"The way to get things done is not to mind who gets the credit for doing them." - Benjamin Howett
October 7, 2002 at 10:49 am
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.
"The way to get things done is not to mind who gets the credit for doing them." - Benjamin Howett
October 7, 2002 at 10:19 am
Antares686, thank you very much.
"The way to get things done is not to mind who gets the credit for doing them." - Benjamin Howett
October 6, 2002 at 1:52 am
I GOT IT!!!
I just forgot to assign value to SQLRestore.Action (see my snippet).
bmsjr,Warren, thanks very much!
"The way to get things done is not to mind who gets the credit for doing them." - Benjamin Howett
October 6, 2002 at 1:41 am
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...
"The way to get things done is not to mind who gets the credit for doing them." - Benjamin Howett
October 5, 2002 at 12:04 am
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...
"The way to get things done is not to mind who gets the credit for doing them." - Benjamin Howett
September 12, 2002 at 11:55 am
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...
"The way to get things done is not to mind who gets the credit for doing them." - Benjamin Howett
September 1, 2002 at 11:26 am
quote:
Did they give a reason why (for not using Hungarian)?
Hi Warren. According to MS,...
"The way to get things done is not to mind who gets the credit for doing them." - Benjamin Howett
August 16, 2002 at 12:08 pm
Viewing 15 posts - 16 through 30 (of 35 total)