RE: setting query timeout value for a single statement
Use: SET QUERY_GOVERNOR_COST_LIMIT and check in BOL for more info
2003-06-20
security
RE: setting query timeout value for a single statement
Not that I'm aware of. Steve Jones sjones@sqlservercentral.com http://qa.sqlservercentral.com/columnists/sjones www.dkranch.net
2003-06-20
RE: Nested transactions in nested sprocs- possible?
Some observations: 1a) Rollback tran affects all active transactions. The commit is meaningless because the only transaction has just been rolled back. 1b) Code works with the save point because the rollback was specific to the save point. 2a) No problem with transactions over nested procedures. 2b) You can return codes with care. We use […]
2003-06-20
1 reads
RE: Enjoying QOD
Agree! I am confused about the points credited. What are these for and where to look for the total points?
2003-06-20
1 reads
RE: SQL Server Agent fails to start - no error msg
Hi Csaba, quote: We have a Win2000 server (SP2) with SQL Server 2000 (SP3). The SQL Server service is running fine without any problem but recently the SQL Server Agent could not be started. There's the following error in the Event log: "The SQLSERVERAGENT service terminated unexpectedly." This is the content of the latest Agent […]
2003-06-20
RE: Find transaction history
Hi tyang, quote: Again since my boss does not want to spend much money on the third party tools, I will try it on my own, but there are too many tables, so it is hard to set the triger on every table. maybe you should tell your boss, to consider the implicit cost when […]
2003-06-20
RE: The Scheduled jobs (6.5) suddenly started failing
From what you tell it sounds very much like the server accepts Windows authentication only. The sa account is no Windows NT account and therefore can't log on if you use Windows authentication. quote: I have checked the registrty permission’s on HKEY_LOCAL_MACHINE\Software\Microsoft\MSSQLServer\MSSQLServer The local Administrators group has Full Control (ie read/Write) of this key. The […]
2003-06-20
RE: creating a db user role
You only need to allow access the the user db, and optionally place them in a user-defined role. For the SP in that db that creates a temp table, just grant execute permission to the user, or to public (the lazy way ), or to the user-defined role. No tempdb permissions are required.
2003-06-19
RE: creating a db user role
Be careful of assigning db_ddladmin for the purposes you've described. It will give the users permission to manipulate object definitions (tables/views/SPs), but not the execute permissions you require. Unfortunately SQL doesn't have a db_ExecuteAnyUserProcedure role. You need to grant execute rights on each stored proc. The public execute permission problem is a weird one. Often […]
2003-06-19
RE: creating a db user role
All I want to do is to give users read,write and execute permission on the database. So I thought of creating a new db role and assign db_reader,db_writer and ddl_admin roles.What should I do then? By the way, I restored a production dump to test environment. Stored procedures which has execute permission to public in […]
2003-06-19
Blogs
The Future of the Social Web Is in Good Hands
By Rob Sewell
The Social Web Foundation is aiming to grow the fediverse and make the social...
Monday Monitor Tip: Compliance Checking for Old Versions
By Steve Jones
A customer recently wanted to know if any of their instances were too old...
Making Legend Order Match Segment Order in a Power BI Stacked Column Chart
A reader of one of my previous posts pointed out that the legend order...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers