Hi all I have a stored procedure which when executed is deadlocking. The stored procured has set: SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED It...
I have two sql2005 servers, both at same sp level. At first glance, the publisher looks to be up with no issues. When I view the replication...
Even with sp1 and the added "first level folder checkbox", we have several SQL2005 installs that have this issue, where the cleanup tasks DO NOT...
Hi Is it possible to create a Delete Trigger that not only captures the affected row, but also collects information about the user doing the...
I'm trying to create a trigger that will concatinate two fields upon an insert or update. I've tried this: CREATE TRIGGER fieldCat ON card AFTER...
Hi. I'm trying to select data from a row in a table, add a string to that and insert the altered data into another field in the same row. Current...
Hi On SQL2005 server, we have a stored procedure that runs when run manually, but fails when run as a scheduled job. This SP connects back to a...
Hi What are the options for encrypting the SQL data within a SQL database.
Here's the index builds on the two tables you asked about. CREATE INDEX [T_APPLICANT_DETAILS4] ON [dbo].[T_APPLICANT_DETAILS]([APPL_ID],...
I assumed the scans were the result of improper indexes. The user has a choice of between about 50 search options. In this case I believe I picked...
Hi.<br />I have a vendor app that on particular searches is very, very slow. Looking at profiler I see it doing hundreds of cursor fetches. The...
Hi. My current database is on a single SQL server. I want to move the database to a cluster environment. What steps are involved and what pitfalls...
I can't get coherient enough results to post anything meaningful. Basically, in table A there is a record with a userid field. That userid field...
Select a.accountID, a.userid, b.accountid, b.userid, b.account_type, b.account_open From load a INNER JOIN account b ON a.userid = b.userid Where...
Yes, I've tried that. The problem is that the left side of the query will return one record, but the right side will have as many as 6 corresponding...
Hi Table A has an ID field Table B has ID field and AccountsID I need to form a query that will match any record in table A with multiple records in...
Hi. We have to move our cluster from the current 172.10.10.x to 168.1.100.x network. Is there a procedural document out there that deliniates the...
What exactly does it mean when, per Microsoft, that there is no "Http service endpoint" support in express and workgroup edition?
Is there any clear downside or disadvantages in the SQL Workgroup Edition, if so, what are they?
Hi We have(had) a cluster. Node 1 is gone and has to be reinstalled. After evicting from cluster and rebuilding the server with same name, same IP,...
Separate names with a comma.
