Viewing 15 posts - 31 through 45 (of 131 total)
I believe the admin access is needed to create ActiveDirectory information for the cluster like ServerName configured to the IP address. If your AD administrator can create those things before...
November 14, 2013 at 10:09 am
If you right-click a database in Management Studio and go to the Properties of the database, there is a Permissions menu choice.
You can Grant Permissions for a login to Delete...
November 13, 2013 at 7:09 am
read the Security Considerations on this link for this information.
http://technet.microsoft.com/en-us/library/ms179410(v=sql.105).aspx
thomas
November 13, 2013 at 7:06 am
You probably need to stage the data in a table, then use T-SQL as Source Component and write CASE statement in T-SQL.
Thomas
November 13, 2013 at 7:04 am
I am glad you found something helpful.
Thanks also for posting your solution because now other people can use it and Bing It! 😛
Thomas
October 31, 2013 at 1:56 pm
I have never seen that happen, so I am not sure why.
Sorry,
Thomas
October 30, 2013 at 7:40 am
yes, this guide should help you
thomas
October 30, 2013 at 7:39 am
If you go to Tools menu choice then Options, you should see a Source Control on the Tree View on left.
On Plug-in Selection you should be able to choice TFS,...
October 30, 2013 at 7:37 am
You probably want to read SQLSkills posting from Paul Randall and Kimberly Tripp to understand the effects of what you want to do.
October 30, 2013 at 7:33 am
Yes, it sucks but on a cluster that is the case. It is for failover and usually cluster setups should have a new instance on a different cluster node.
The...
October 30, 2013 at 7:32 am
Yes there are, if you right click the connection in Management Studio and go to Properties then go to the general tab.
Of course, these are system settings that usually should...
October 30, 2013 at 7:29 am
If you are selecting to connect to a table in the OLE DB (or ADO) Source, try use a SQL Command instead and build the SQL yourself without the collate.
Not...
October 30, 2013 at 7:20 am
Wow, I was already formulating follow-up questions. You got me.
Thomas
April 1, 2013 at 9:08 am
Excellent article.
I believe these people are just like me when I became a DBA. You never have seen a 3000 line SP, then you are asked to look into it.
The...
March 28, 2013 at 7:40 am
Viewing 15 posts - 31 through 45 (of 131 total)