Viewing 15 posts - 4,231 through 4,245 (of 6,105 total)
In order to be able to update the system tables, you have to use sp_configure to allow updates. You'll have to set SQL Server to show advanced options, first.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_config_3wmr.asp
However,...
June 20, 2003 at 6:59 am
quote:
Secondly, the comfort of having two physical boxes ("oh great, so if someone hacks IIS they can't get to my SQL box")...
June 20, 2003 at 6:45 am
SQL Server can run perfectly fine if it's not an administrator on the system. There are limitations, of course. In reality,not being an administrator on the box is more limiting...
June 20, 2003 at 6:35 am
Yes, you can nest roles. You'll want to make the user-defined role (the one you create) a member of the fixed database roles... not the other way around as pointed...
June 19, 2003 at 12:46 pm
Services.exe is the services manager for the OS. The only KB article I've found (perhaps others will have better luck) is if it is started interactively.
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to...
June 19, 2003 at 8:32 am
quote:
One of our concerns is keeping referential integrity across databases, since many of the tables in the application databases would reference both...
June 19, 2003 at 8:29 am
As previous posters have indicated, these times really seem suspect, even when there is a value. However, you can generally get a ballpark number for long-running queries.
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start...
June 19, 2003 at 8:26 am
Query Analyzer is part of the client tools. As SQLBill has said, if you just want the tools to connect to SQL Server (and not a whole new SQL Server...
June 18, 2003 at 12:52 pm
quote:
Granted, revoked, denied. Semantics, purely semantics. Why can't engineers, programmers, application designers, system administrators or any other technologists use the language in...
June 18, 2003 at 12:22 pm
Ok, I went back to BOL and looked at the syntax.
The IDENTITY option is only available if you are adding a column. ALTER COLUMN allows you to add or drop...
June 17, 2003 at 8:55 am
Wait. Are there values in the table already for the column in question?
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
June 17, 2003 at 8:03 am
Try removing the NOT NULL
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
June 17, 2003 at 7:50 am
1) Is there an IDENTITY column already on the table?
2) Can you post your syntax?
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
June 17, 2003 at 7:21 am
You can explicitly grant statement permission rights within a database. For instance:
GRANT CREATE TABLE TO HostedCustomer
However, prohibiting acccess to system tables and system stored procedures is a bit more problematic....
June 17, 2003 at 7:04 am
You can add an IDENTITY property by using ALTER TABLE, but you cannot remove an IDENTITY property. The way EM handles it is it creates a new table without the...
June 17, 2003 at 6:59 am
Viewing 15 posts - 4,231 through 4,245 (of 6,105 total)