Viewing 15 posts - 136 through 150 (of 312 total)
forget it. This works but is this how I should do it?
-q "EXIT(CREATE USER [Domain\Blah] FOR LOGIN [Blahs])"
May 11, 2009 at 3:58 pm
Now that I am thinking about it when you run the alter/create have a "GO" statement afterwards you should be good. There should not be a need for a...
May 5, 2009 at 10:50 am
If you are saving these as views then you should not have to refresh. If you are running these with create or alter statements from TSQL you should run...
May 5, 2009 at 9:39 am
Will there only be two rows...If so could you use a subquery to look for the second instance?
April 28, 2009 at 8:46 am
you are not following what I am looking for. this is not a server that will be controlled by me. This is an application that has an AD...
April 20, 2009 at 8:44 am
Sure...
the application they are writing has roles within the application itself...A decision made way above me.
These roles can be associated to users of the application
These roles can...
April 17, 2009 at 3:09 pm
I am also looking forward to part due. I really try not to use cursors, but sometimes get in traps where I can not think of a better solution....
April 14, 2009 at 1:10 pm
It was strange. I am currently running two versions of SQL on my local box. I am running a developer edition and that currently is set to run...
March 12, 2009 at 1:12 pm
I figured it out. I am running multiple instances of SQL. It was a permission issue
March 12, 2009 at 12:10 pm
view Tabel Contract
Nr Pricedate PriceMethode
1 01-12-2008 A
2 ...
March 12, 2009 at 10:40 am
Could you add a field as a varchar and use the computed Column Specification "Formula" to design a unique key.
February 27, 2009 at 3:27 pm
Yes what I have documented is if the user wants to install this way they will have to create a standard account to have the permissions work on the network...
February 25, 2009 at 12:15 pm
Roy thanks for the post. That is what I read yesterday. Here is another post that discusses this
http://www.sqlservercentral.com/Forums/Topic325966-5-2.aspx
I can see a way to get around this...
February 24, 2009 at 11:30 am
Roy is correct. It has something to do beyond the user executing the application. I have seen a few posts and I do not think this will work....
February 24, 2009 at 9:18 am
The last statement is accurate. since you are passing tables in there will be no optimization. Plus the execute statement is firing off different procs so again no...
February 24, 2009 at 7:36 am
Viewing 15 posts - 136 through 150 (of 312 total)