Viewing 15 posts - 37,906 through 37,920 (of 39,456 total)
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
You can't really do this because the exec() statement essentially "shells" to another batch. The best way would be to build a table (perm or global temp ) and then...
February 25, 2002 at 11:13 am
In reading Pauls reply, I just thought of something. Has anyone tried to simulate clustering using instances? Or can anyone? Be curious to see if the "shared disk" can be...
February 25, 2002 at 11:10 am
Sorry for the late reply. Can you log into the server as the SQLAgent account and exucute them? Have you checked that none of the other packages have started running...
February 25, 2002 at 11:08 am
Viewing 15 posts - 37,906 through 37,920 (of 39,456 total)