BEGIN TRAN DBCC CHECKIDENT('Table1',RESEED,1) DBCC CHECKIDENT('Table1',RESEED) COMMIT TRAN This will reset to the next non-duplicate value. The RESEED option will only reset the next-in-sequence upward, so set to 1, then let the RESEED do it's work. -Dan
2003-06-19
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 out. 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 Edited by - bkelley on 06/19/2003 12:47:11 PM Edited […]
2003-06-19
You didn't copy my code quite right. You left out the quotes, which indicate that the @sql variable is a string: ... SET @sql = 'SELECT * FROM tblEmployee WHERE EmpID LIKE ''' + @EmpID + '''' EXEC sp_executesql @sql ... Without the quotes, it won't work.
2003-06-19
quote: Do you get the error right away or during the CURSOR_TBLDEF loop? If is is during CURSOR_TBLDEF loop perhaps SQL is grabing a big chunck of the syscomments entry and allocating too much for the record, are there any large table/procedure definitions in your DB? I was a little bit unprecise! I only need […]
2003-06-19
Hi bj007, quote: Can I create a db role and assign the existing roles to it. Like, db_datareader,db_datawriter,db_ddladmin needs to be given to my new role ? Seems like reinventing the wheel? Any reasons why? And what about the other way? Cheers, Frank
2003-06-19
Muliple View are not a feasible option. The WHERE cause is being built dynamically on a web page and the number of columns possible are over 20. Go back to my original request : I cant use a CURSOR because EXEC are not allowed in CURSOR SELECT statement. is this true? do I have any […]
2003-06-19
2003-06-19
Hello jPipes Your suggestion worked, however, from access I still have to specify the exact EmpID I'm working with. Exec UpdateInfo @EmpId = '1234' I have tried the other suggestions, but still unable to substitute a variable for '1234' and make it work. Thank you all for your help. I am determined to figure this […]
2003-06-19
quote: Set @EmpID = '1%' Select * from tblEmployee where EmpID = @EmpID This will return all Employee ID's that begin with a 1, but I'm only looking for the EmpID of the record I'm working with. Actually, you'll need to use the LIKE operator to make this work, and you will have to use […]
2003-06-19
If you restrict the SQL username to 'dbo' that will exclude any other users - where the username is actually populated. But if SQl user is null it gets included in the trace whatever you do. Probably best is to capture the trace to a table (see SQl profiler help), then you can search the […]
2003-06-19
1 reads
By Rob Sewell
The Social Web Foundation is aiming to grow the fediverse and make the social...
By Steve Jones
A customer recently wanted to know if any of their instances were too old...
A reader of one of my previous posts pointed out that the legend order...
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