Viewing 15 posts - 2,491 through 2,505 (of 3,738 total)
Click on the first link in my signature block. 😛
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/
August 3, 2011 at 5:12 am
Leo.Miller (8/1/2011)
Welsh Corgi (7/30/2011)
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/
August 1, 2011 at 5:11 pm
If you have a permissions issue on the account that you are using to run the packages every package will fail.
You have not answered any of the questions that 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/
August 1, 2011 at 12:38 pm
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/
July 31, 2011 at 5:29 pm
You could get the Host name using a Server SIde Trace.
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/
July 31, 2011 at 11:29 am
greatsqldba (7/30/2011)
Has anyone used ms access as a front end interface for inserting, updating, and deleting data from a sql server database? Are there any other options available instead of...
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/
July 31, 2011 at 11:01 am
You just need to add a condition to the WHERE Clause on the DELETE from the ProspectsInCampaigns.
After you do that and remove the duplicates you should create a Primary Key...
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/
July 30, 2011 at 2:25 pm
You should have the same users in your Development Environment as your Production Environment.
That way your Development Environment mimics your Production Environment.
If that is not the case you may want...
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/
July 30, 2011 at 11:49 am
beejug1983 (7/30/2011)
Like : Server 1 -- database1--users1,2,3,4 took the backup of...
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/
July 30, 2011 at 11:24 am
Good point if you create the Login with the same SID then you will not have orphaned Users.
If you already have a lot of Logins on the target server and...
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/
July 30, 2011 at 10:11 am
The Users and permissions to the Database will be retained with the refresh.
You will need to transfer the Logins for each Database User.
You will also need to fix Orphan...
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/
July 30, 2011 at 9:59 am
What?
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/
July 29, 2011 at 7:20 am
Are you attempting to perform the installation using an Account with Administrator Privileges?
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/
July 28, 2011 at 7:27 pm
I would use UserID as the Primary Key. It will be unique, natural and by using that it reduces the probability of error.
Indexes are usually created on columns that are...
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/
July 28, 2011 at 5:19 pm
Look at the last post on the following link.
http://forums.iis.net/t/1166244.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/
July 28, 2011 at 2:37 pm
Viewing 15 posts - 2,491 through 2,505 (of 3,738 total)