Maybe this would work: sp_grantlogin [@loginame =] 'login' sp_grantlogin sp_revokelogin Note that the SQL security account procedures and the NT security account procedures differ. If you got a snapshot of all of the logins/role membership/permissions for the NT accounts, and their NT account name has not changed, then you could scan through them and use […]
2003-12-01
quote: can't use cursor because can't declare variable as text If the table has a PK then you could retrieve the PKs once and use a cursor to loop thru them and then action the select (using the PK instead of patindex) and updatetext.
2003-11-27
1 reads
The proposed answer is the best choice. It does disconnect all users connected to the database which is being ALTERed. However, the wording would be more accurate, if it stated ' everyone connected to the database being altered (NOT CONNECTED TO THE SERVER)...' IS THIS ADDITIONAL WORDING NECESSARY???
2003-09-03
2 reads
I think it depends on the severity of the error, some of the errors abort and rollback the transaction and it will be difficult to trap in SQL. Can't you trap/look at the error returned to your app, if its not your known error returned then you will have to do the job yourself.
2003-09-03
Try this... SELECT ISNULL(min(BudgetId), ISNULL((SELECT max(BudgetId) + 2 FROM tblBudgetYear), 2) - 1 FROM tblBudgetYear t1 WHERE NOT EXISTS (SELECT 1 FROM tblBudgetYear t2 WHERE t2.BudgetId = t1.BudgetId - 1) AND t1.BudgetId > 1
2003-08-29
1 reads
2003-08-13
I would like to know this as well as well. Do you not allow regular users to create stored procs? I thought this was a standard practice?
2003-08-07
I want you to see this solution, may be it help you. here is the solution of the Hang Problem (ODBC Timeout) between any program and SQL server 2000 or 7 : When you want a report which based on complicated queries joined from several tables, These tables are updated frequently, then you lock these […]
2003-07-28
If you use the value of the trigger's bitmask variable (function) COLUMNS_UPDATED(), then you should be able to analyse that bitstring, joining with syscolumns or information schema views to determine the column name.
2003-07-23
1 reads
2003-07-22
1 reads
By Steve Jones
incidental contact high – n. an innocuous touch by someone just doing their job...
By Steve Jones
The survey is out now and you can share your experiences for a chance...
By Rob Sewell
"We can really be dangerous if we want, without being too afraid of it."
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers