Viewing 15 posts - 37,996 through 38,010 (of 39,456 total)
I agree with Andy. There is much more flexibility in SS2K. If you upgrade, then you will find it easier to make other changes.
Steve Jones
February 15, 2002 at 10:28 am
Not that I know of. I think if you want to know this, you will need to build something to track it.
Steve Jones
February 15, 2002 at 10:25 am
If you do not have a fixed number of levels, it is difficult to do this without recursion. At least in T-SQL.
One thing you could do is only populate come...
February 14, 2002 at 8:01 pm
Or (more in the spirit)
Your servers rest on concrete blocks on the data center.
You might not be a DBA if you think the best way to delete a table is...
February 14, 2002 at 2:56 pm
February 14, 2002 at 2:53 pm
You are welcome. Don't really know of a way to run a stored proc asynchronously. I think it won't return intermediate result sets.
HAve to test it though?
Steve Jones
February 14, 2002 at 2:17 pm
Personally I be scared to see stored procedures or any SQL object in VB, C, etc. Those guys are funamenatally row or object oriented. SQL and RDBMSs are set oriented....
February 14, 2002 at 2:15 pm
February 14, 2002 at 2:11 pm
Can't be imported. If you want to move as flat files, save as structured storage file.
Steve Jones
February 14, 2002 at 2:07 pm
Not really. You could insert a value into some other table and query this periodically.
Steve Jones
February 14, 2002 at 2:06 pm
I work at a starup( 35 people, 8 in IT) and all developers have Domain admin rights, including me. Not that I agree with this, but havn't been able to...
February 14, 2002 at 12:21 pm
on sql server 2000, the sp_change_users_login will help fix user and logins.
Steve Jones
February 14, 2002 at 12:18 pm
you need to include day and year, or convert to characters and strip off the times.
Steve Jones
February 14, 2002 at 11:26 am
February 14, 2002 at 11:25 am
The zeros would be a problem unless you store a 0 value for each date. I see why you want a table of all days.
For the basic data, couldn't you...
February 14, 2002 at 11:07 am
Viewing 15 posts - 37,996 through 38,010 (of 39,456 total)