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.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
September 8, 2011 at 4:38 am
The problem is related to the package ProtectionLevel set to EncryptSensitiveWithUserKey
Try the following links.
http://msdn.microsoft.com/en-us/library/ms138023.aspx
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
September 8, 2011 at 4:12 am
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
September 8, 2011 at 3:45 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...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
September 7, 2011 at 7:04 pm
I have to agree that the messages are cryptic.
Regards.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
September 7, 2011 at 1:46 am
What happens if you log on via SSMS?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
September 6, 2011 at 11:39 pm
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.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
September 6, 2011 at 4:22 pm
Could you post your DDL and Sample Data as specified in the first link listed below?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
September 6, 2011 at 3:11 pm
Viewing 15 posts - 2,296 through 2,310 (of 3,738 total)