Viewing 15 posts - 1 through 15 (of 135 total)
Kevaburg, you were correct in saying it wouldn't work. I was trying to explain the situation to the other 2 posters why I didn't have the luxury of using...
March 26, 2013 at 7:20 am
Lowell, you are correct that I can add a group and that is what we would like to do but from everything I have read, I can't have one AD...
March 26, 2013 at 6:33 am
Thanks for the reply. Let me explain what is going on. We are implementing Tableau Server. Tableau is a data discovery/BI tool and server allows sharing of...
March 26, 2013 at 6:14 am
Kevaburg, thanks for the reply!
I want to utilize impersonation within SQL Server and not within AD. I want the one AD login to run queries on SQL...
March 24, 2013 at 6:31 pm
Its been a few months since I have worked with SSRS but if I remember correctly, the current version will not allow you to have 2 data sets on the...
August 26, 2009 at 6:11 am
My first question for you would be is if this is a one time process or if you have to continually do this? If one time, it would be...
June 23, 2009 at 1:23 pm
its the same procedure that you would use for sql logins
grant select, update, insert, delete on objectname to domain\userorgroupname
hth,
john
November 13, 2008 at 7:55 am
You can also eat up a lot of disk space with the log file depending on how many counters you are tracking & how long you have the perfmon running....
November 13, 2008 at 5:26 am
From what I have seen, SQL 2008 Intellisense is still light years behind SQL Prompt. I don't understand how a company like Microsoft cannot get intellisense to work!?!?! ...
September 12, 2008 at 12:50 pm
A nice sample app that we have always been looking for is a code & control table maintenance tool. I am sure we all have tables out there that...
August 7, 2008 at 5:10 am
I am with Kendall on this one. I install SSMS on my production servers because it becomes very necessary in some instances. Such as if you are offsite...
July 31, 2008 at 5:02 am
As everyone stated moving from 32bit SQL to 64 bit is fairly easy. We ran into more issues with the OS moving to 64 bit. The biggest being...
July 7, 2008 at 7:03 am
One method for moving an SSIS package from one server to another is the following:
1. Connect to SSIS within Management Studio
2. Locate the package you want to move
3....
July 7, 2008 at 6:58 am
As Gilamonstor stated, if you are only using 4gb, you don't need to use AWE or the switches. Just set your min & max memory levels for SQL:
sp_configure 'min...
April 10, 2008 at 4:51 am
Wildh is right, you can't process a AS 2005 cube from a 2000 dts package that is running in legacy mode. However, its not a hard job to create...
November 30, 2007 at 11:26 am
Viewing 15 posts - 1 through 15 (of 135 total)