Viewing 15 posts - 2,296 through 2,310 (of 3,738 total)
Jack,
Sorry to hear about your father.
My prayers and thoughts are with you and your father.
Regards.
September 8, 2011 at 8:10 am
There is a link to a MeasureUp Demo from the Following URL.
The link also includes information about the test.
SelfTest is good but it is not free.
Some of the information that...
September 8, 2011 at 4:38 am
The problem is related to the package ProtectionLevel set to EncryptSensitiveWithUserKey
Try the following links.
September 8, 2011 at 4:12 am
If the logins do not exist on Server B you will need to create and execute a Script to Create the Login.
You will also probably need to fix Orhan Users...
September 8, 2011 at 3:32 am
09/07/2011 03:15:41,Server,Unknown,SQL Server is terminating because of a system shutdown.
The Server shutdown. Looking at the time it looks like it may be a scheduled reboot.
At what time are you...
September 7, 2011 at 7:04 pm
I have to agree that the messages are cryptic.
Regards.
September 7, 2011 at 9:28 am
Please do not be offended but why are you doing this and what will this accomplish?
What Business Requirements will this fulfill?
September 7, 2011 at 1:46 am
Developers should never be a member of the sysadmin role Fixed Server Role in Production.:w00t:
It is not DBA' vs Developers it is just good practice.
September 6, 2011 at 9:37 pm
mister.magoo (9/6/2011)
I do use referential integrity at the application level as it prevents unnecessary attempts to insert data into the database that will certainly fail.
What you are referring to...
September 6, 2011 at 9:23 pm
The way that I have handled Active/Inactive Flag is that the SP that is used to populate the List Box with a WHERE Clause that filters the records.
Respectfully there is...
September 6, 2011 at 5:09 pm
Make sure that you add a Foreign Key Constraint.
You will not be able to remove Codes for that would be a violation of the Foreign Key Constraint.
Setting the Active/Inactive Column...
September 6, 2011 at 4:43 pm
I always use lookup tables.
I would not just let anyone add values to the table. THis need to be well thought out or you will have issues.
I add an Active...
September 6, 2011 at 4:22 pm
Could you post your DDL and Sample Data as specified in the first link listed below?
September 6, 2011 at 3:11 pm
Viewing 15 posts - 2,296 through 2,310 (of 3,738 total)