Viewing 15 posts - 38,251 through 38,265 (of 39,804 total)
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
It's pretty easy to build a web interface to allow edits. That would allow you to trap the changes.
Alternatively you could get a copy of Log Explorer (see our newsletter...
February 25, 2002 at 11:35 am
In SQL this would be a compound PK. You could setup two fields as the PK with
ALTER TABLE dbo.<xxx, char( 32), TblName> ADD CONSTRAINT
Table_PK PRIMARY KEY NONCLUSTERED
(
FieldA Int
...
February 25, 2002 at 11:19 am
Thanks guys, I have long felt that it was impossible overall and have adopted the items mentioned. There is always some maintenance window, sometimes on the spur of the moment...
February 25, 2002 at 11:17 am
Viewing 15 posts - 38,251 through 38,265 (of 39,804 total)