data masking

RE: Linked-Servers in a SQL clustered environment

• by Don Peterson

• Redgate

• Reply

I think this is highly unadvisable.  Linked Servers have their place, but they tend to be rather large security holes.  First off, you would have to use SQL authentication with the username and password being sent across the internet.  Even if it is encrypted, that would tend to keep me up at night if my […]

2005-05-20

RE: Primary Key Field - Identity

• by Mark-163717

• Redgate

• Reply

You could create a stored procedure that would: 1. get the last identity for the table 2. drop the table 3. create the table with the new identity seed value set to the last identity you retrieved in step 1 I am not sure why you want to truncate the data....I am sure you have […]

2005-05-19

1 reads

sp_getAppLock which Resource are locked?

• by Carl-B

• Redgate

• Topic

Hello Everyone,Is there a way to get information on resource name that are locked using the stored procedure sp_getAppLock?The server seem to expose the first 4 characters of the resource locked but encode the remaining with headecimal values (if we look using sp_lock or in syslockinfo).We would avoid to try to lock the resource in […]

2005-05-19

65 reads

RE: Friday the 13th

• by okie_greg

• Redgate

• Reply

Hey Steve! Kids are great aren't they.  I have to forewarn you though, "And more reasonable." probably won't last forever.  Just like most things in this wonderful world, I have found my children's reasonability is cyclical.  When very young, you certainly can not reason with them, but they slowly rise on the curve of reasonability.  It has been my […]

2005-05-19

CSV Rendering

• by Prasad-Bhogadi

• Redgate

• Topic

I have a report which takes lot of time to render, rather the stored procedure returning the data to the report consumes good amount of time because of the number of records and conditions in the stored procedure, So what I need to implement is when the report is invoked I am displaying different rendering […]

2005-05-18

2 reads

RE: recompile

• by Sushila Iyer

• Redgate

• Reply

sp_recompile automatically forces sql server to mark an sp for recompilation - regardless of whether any modifications have been done to the tables associated with it! Did I misunderstand your question ?

2005-05-18

RE: copy tables with indexes

• by philcart

• Redgate

• Reply

The better approach is to provide a bit more information What servers are you running? Are the databases on the same server? How much data is in each row?The more details along these lines the better. 

2005-05-18

RE: Correct and complete optimisation step sequence?

• by Tom-Brehony

• Redgate

• Reply

Thanks for the clarifications Chris. Tom.

2005-05-18

RE: Restore Master database failed!

• by Martin-Mojzisek

• Redgate

• Reply

see this article for explanation/solution to your problem: http://support.microsoft.com/kb/264474/EN-US/

2005-05-18

RE: SQL Server 2000 SP4

• by petmani

• Redgate

• Reply

This is found in SQL Server Books on-line. Initially we had 4 GB (3 GB for SQL + 1 GB for OS) with AWE Option disabled. Once we upgraded from 12 GB (10 GB for SQL + 2 GB for OS) we enabled AWE. It makes sense to enable AWE if we have more than […]

2005-05-17