Viewing 15 posts - 1,591 through 1,605 (of 6,105 total)
Jai, I understand what you need to do, but I don't know what your question is. Do you need to build the database connection string?
October 17, 2007 at 7:59 pm
In SQL Server, roles can be nested, so that needs to be taken into account. In SQL Server 2000 you'd have to do recursion using temp tables. In SQL Server...
October 17, 2007 at 7:57 pm
Here is what I see. This is with the Developer Edition. Your groups may be named differently depending on instance names, etc. For Express, these should all be security groups...
October 17, 2007 at 7:36 pm
The default database location only determines where SQL Server will attempt to locate new databases. It'll attempt to locate databases it knows about in the location where the files were...
October 17, 2007 at 7:24 pm
Yelena Varshal (5/22/2007)
Also try telnet command using Kerberos port 88.
On a normal member server this port is not enabled. This should only be on when the Kerberos Key Distribution Center...
October 17, 2007 at 7:07 pm
tcp/445 is a generic port, so you can't assume that because you can connect to it SQL Server allows you to connect via Named Pipes. With regards to SQL Server...
October 17, 2007 at 7:03 pm
The CREATE TABLE right is going to grant DROP TABLE rights. In this case, the DDL solution proposed is your best bet. However, you may want to put some logic...
October 17, 2007 at 1:41 pm
sqlquery (10/16/2007)
Thanks All for your comments ,much appreciated , so there is any supportive document to support this kind of scenario ?
There are general documents on clustering and SQL Server...
October 17, 2007 at 1:34 pm
sqldba (10/11/2007)
Eventually i found that the root cause of this issue is Public Server Role.
You mean public database role. There is a difference between the two.
The public server role...
October 17, 2007 at 1:32 pm
I believe so. One way to test is to create a login with no permissions and run SELECT @@SERVERNAME and see if it can execute it. It should be able...
October 17, 2007 at 1:28 pm
ben_634 (10/11/2007)
October 17, 2007 at 1:25 pm
Likely it is the SIDs. Try this: pick one particular login that you know has few ties to databases. Run an sp_revokelogin against the NT4 domain login. Check to see...
October 16, 2007 at 3:02 pm
Doing a trigger for this is a bad idea, exactly for the reason you are encountering. Can you not do the rename in the program code? If not, you may...
October 16, 2007 at 2:58 pm
From Books On-line:
How to: Install Reporting Services Side-by-Side with an Earlier Version
October 16, 2007 at 2:55 pm
Seen demos of Lumigent's, but haven't actively used any of them. Have Apex SQL Audit, which should probably be on your list. However, what are your requirements with respect to...
October 16, 2007 at 2:48 pm
Viewing 15 posts - 1,591 through 1,605 (of 6,105 total)