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...
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.
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...
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,...
What do these numbers show for sqlserver:lock timeout/sec in perfmon? Thanks. kd \SERVERNAMESQLServer:Locks(_Total)Lock Timeouts/sec 0.082844233 0...
we have an app that suddenly generates the following errors in the SQL error log when we attempt to start the app: Configuration option 'show...
Hi my "Current log" has grown beyond the 5 meg mark by a little and can not be viewed - just hangs until I force quit EM. When I look at the...
I don't think this is possible, but does anyone know of a way for end-users to maintain their SQL connections during a failover. When the other node...
Why does this script return logins with null passwords, even when I'm sure the passwords in some cases are not null USE MASTER Select name, password...
HI. Anyone know of a document/link which provides a good SQL server security audit/best practices. Thanks
Separate names with a comma.
