Viewing 15 posts - 37,501 through 37,515 (of 39,456 total)
v6.5 does have some locking issues in places, especially if you make use of temporary tables.
I'd need more testing, but this doesn't surprise me.
Steve Jones
May 7, 2002 at 3:51 pm
Which exam?
The admin exam is different from the database exam.
I wrote the Sybex book for the database exam so I am biased.
Steve Jones
May 7, 2002 at 2:50 pm
The only way I can think of is to make some utility that will execute BCP or a DTS package and set a row end there. For a data import,...
May 7, 2002 at 1:19 pm
I used DBArtisan and RapidSQL a couple years ago. Nice products, but nothing special over QA. The SourceSafe integration was kind of fuzzy. I used EditPlus for ASP/HTML, and I...
May 7, 2002 at 12:23 pm
Profiler snags an event, I believe when the process starts. The last command, should be in DBCC InputBuffer. Are you sure the spid is still active? It might have timed...
May 7, 2002 at 12:19 pm
Antares has great advice. If you use EM to restore on the new server from backup, you change the path's for the files on the "Options" tab.
Steve Jones
May 6, 2002 at 10:42 am
I believe for the context of the trigger, Andy is right. You can join on the table itself in the query (along with inserted) and it works.
Steve Jones
May 6, 2002 at 10:39 am
I've used their software, not sure if this model, and it wasn't always stable. Most of the time, but occassionaly it flipped. I'm guessing they don't want to spend the...
May 6, 2002 at 10:37 am
A parametized query will work. You can also use a second package to call your package repeatedly, changing the value of the query for each to match a new recordset.
Steve...
May 6, 2002 at 10:36 am
I've had this issue on SQL Server 2K as well. It seems sporadic and I can't pinpoint why. I do have multiple drives mapped, some to different domains, but I...
May 6, 2002 at 10:33 am
How are you transferring? By IP or FQDN (use FQDN) or by hostname? If hostname, then you might have name resolution problems. Setting up a good WINs setup is a...
May 6, 2002 at 10:31 am
Brian is on a good track. This is likely a security issue.
I did the reverse, sending from the colocaiton to our office, but I choose FTP. It was cleaner than...
May 4, 2002 at 1:45 pm
Only a few users/logins and they were synched with sp_change_users_login (we use SQLAuth). They were added with sp_addlogin because our backup box was "appropriated" a couple months ago for...
April 30, 2002 at 2:17 pm
April 30, 2002 at 2:12 pm
SQL 2000 has more trigger options, but I'm not sure there is any other difference.
Steve Jones
April 30, 2002 at 11:51 am
Viewing 15 posts - 37,501 through 37,515 (of 39,456 total)