Viewing 15 posts - 37,276 through 37,290 (of 39,818 total)
I keep the permission with the object create script. That way they are added when the object is created.
The first time you do this, it's tough, but once you get...
August 16, 2002 at 9:58 am
Not likely to be anyway to do this except permissions. Is this a big problem?
Steve Jones
August 16, 2002 at 9:52 am
yes, but it will take time to recreate them. Dropping them decreases the load time, not the total time to get the table back to it's state.
Steve Jones
August 16, 2002 at 9:48 am
The listeners do not start unless the server reboots. This might be your problem.
Steve Jones
August 14, 2002 at 12:20 pm
Are you doing this in one transaction? You can set the size of the batch to commit.
Steve Jones
August 14, 2002 at 10:51 am
Is the path for the log file in existence? It will not create it. Use the WITH MOVE option to move the log file to a valid path.
Steve Jones
August 14, 2002 at 10:48 am
A good point and worth considering. as with most things, it depends on the business rules.
There may be a transient environment, like an ISP for example. If I sign up...
August 14, 2002 at 10:46 am
select
b.brochures
, b.pid
, h.holidays
from m_brochures b
inner join m_holidays h
on b.pid = h.BrochuresXid
where h.pid in ( select top 5
h1.pid
from m_holidays h1
where h1.BrochuresXid = b.pid
)
order by b.brochures
Steve Jones
August 14, 2002 at 10:41 am
I built my own (/columnists/sjones/vcspart1.asp).
There are products from Embarkadero, CA, etc. that can help. Search the forums for version control.
Steve Jones
August 14, 2002 at 10:12 am
Looks like a permissions error. Someone must have messed with the permissions on the server, either Filesystem or registry. Can you start it under an adminsitrator account?
Steve Jones
August 14, 2002 at 10:10 am
Stop the server and copy the .mdf file. Then try an attach, overwriting the existing database.
Steve Jones
August 14, 2002 at 10:08 am
What type of math? Require user input? an example might help.
If it's simple math, like value * .40, then I'd
update table
set colA = ColA *.4
where pk =...
August 13, 2002 at 3:01 pm
Update:
Nothing between the servers except a switch. They may be on separate VLans, so it's possible it is multiple switches.
However, I can run these queries together in one batch, with...
August 13, 2002 at 3:00 pm
Viewing 15 posts - 37,276 through 37,290 (of 39,818 total)