Viewing 15 posts - 37,936 through 37,950 (of 39,492 total)
Sorry, no experience on this. I'd double check all the information in BOL and on TechNet.
Steve Jones
February 27, 2002 at 10:42 am
February 27, 2002 at 10:40 am
Two things, check the language setting and the client has more of an impact on the display. Have you changed the W2K settings on the client or the server?
Steve Jones
February 27, 2002 at 10:35 am
For SQL? I've run over 5-6 months on v6.5 with no downtime. Haven't really pushed the envelope on Ss2K, though I'd have to check my current box.
I used to run...
February 26, 2002 at 7:07 am
February 25, 2002 at 4:58 pm
can you post code?
I think you want to build the query using the value of the variable, not the variable.
so if I want to email people named 'steve' and...
February 25, 2002 at 4:55 pm
no. you have to manually check the @@error variable after every statement.
Steve Jones
February 25, 2002 at 3:49 pm
Logins are stored in master..syslogins. Users are stored in the db in the sysusers table. They are mapped together. If you have a "none", then the user-> login mapping is...
February 25, 2002 at 1:14 pm
select *
from table1 t1
inner join table2 t2
on t2.wildcard + '%' like t1.product
Steve Jones
February 25, 2002 at 12:10 pm
Two things:
Global temp tables, unnique to your user connection.
Perm table, include a spid column and poopulate this with @@spid when you run. Be sure to delete all matching @@spid values...
February 25, 2002 at 12:06 pm
They have fantastic rerouting and fault tolerance. BUT, there is still downtime and not just my local circuit. Mostly I deal with data, but I have seen minutes to hours...
February 25, 2002 at 11:59 am
Probably when you run this, there is more of a hit than you need, but if it doesn't run that often, might not be worth it. Of course, it depends...
February 25, 2002 at 11:55 am
It should be possible technically, but over dialup there may not be enough bandwidth. Also, it the sizes grow there may not be enough time to send this via dialup...
February 25, 2002 at 11:50 am
backup database <db name> to disk <disk file path and filename>
backup transaction <db name> to disk <disk file path and filename>
If you need to shrink the log, it doesn't always...
February 25, 2002 at 11:43 am
Yikes? How often would this change? If not often, I'd spend the effort to write the stored procs to handle each case and return the right results. It is a...
February 25, 2002 at 11:37 am
Viewing 15 posts - 37,936 through 37,950 (of 39,492 total)