Viewing 15 posts - 2,491 through 2,505 (of 3,738 total)
Leo.Miller (8/1/2011)
Welsh Corgi (7/30/2011)
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...
August 1, 2011 at 12:38 pm
You could get the Host name using a Server SIde Trace.
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...
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...
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...
July 30, 2011 at 11:49 am
beejug1983 (7/30/2011)
Like : Server 1 -- database1--users1,2,3,4 took the backup of...
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...
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...
July 30, 2011 at 9:59 am
Are you attempting to perform the installation using an Account with Administrator Privileges?
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...
July 28, 2011 at 5:19 pm
Look at the last post on the following link.
July 28, 2011 at 2:37 pm
Viewing 15 posts - 2,491 through 2,505 (of 3,738 total)