Viewing 15 posts - 1,606 through 1,620 (of 2,008 total)
November 15, 2011 at 12:55 am
The Service Master Key is the root of the SQL Server encryption hierarchy. It is generated automatically the first time it is needed to encrypt another key. By default, the...
November 15, 2011 at 12:53 am
We have one job executes procedure on database Bsa and tries to read information from database ADomain.
The TRUSTWORTHY database property is used to indicate whether the instance of SQL Server...
November 15, 2011 at 12:33 am
Disable the anti-virus application and try again.
November 15, 2011 at 12:23 am
@Celko: If you don’t mind, May I ask you a question (based on my general observation so far)?
How do you find time to write such big posts? 😀
November 15, 2011 at 12:13 am
I might mention that the app is a standalone app, which runs only on a user's desktop system (not in a server environment). The app and the SQL databases are...
November 15, 2011 at 12:08 am
The below sproc is fine until today we have some problem.
Please define your problem with consumable data (DDL, sample data, Output format etc.).
November 14, 2011 at 11:57 pm
Few Questions:
•What’s the database recovery model?
•How frequently you backup (full / log)?
•What’s the DB size?
As a quick start if your recovery model is FULL, please take Transaction Log Backup.
How to:...
November 14, 2011 at 11:41 pm
It’s a BIG subject. Please be precise on what do want to secure. However here is something to start with.
Mission-Critical Operations
Security
http://technet.microsoft.com/en-us/magazine/2008.04.sqlsecurity.aspx
November 14, 2011 at 11:36 pm
Have you gone through this document? Please cross check your steps.
Configuring a Report Server for Secure Sockets Layer (SSL) Connections
November 14, 2011 at 11:31 pm
ColdCoffee (11/14/2011)
A GROUP BY and HAVING COUNT(*) > 1 will give you what you want.
It will tell you what to delete. To Delete rows from main table & copy them...
November 14, 2011 at 11:27 pm
FYI: Mean, median, and mode are three kinds of "averages".
Find the mean, median, mode, and range for the following list of values:
13, 18, 13, 14, 13, 16, 14,...
November 14, 2011 at 11:15 pm
If I am not wrong, there are two groups for Remote Desktop Users i.e. 'Local Group' & 'Domain Group'. Please check if your user account is included in 'Domain Group'....
November 14, 2011 at 6:48 am
memymasta (11/14/2011)
1. Create a new user in windows with admin rights and log into that account.
2. Start SQLServer in single connection mode. Link
3. Connect to Managment...
November 14, 2011 at 6:10 am
It's not a run-time error, try-catch can't catch it.
Well, it should.
p.s. A runtime error does not cause a crash unless the person who wrote the code was incompetent and didn't...
November 14, 2011 at 6:07 am
Viewing 15 posts - 1,606 through 1,620 (of 2,008 total)