Ryan demonstrates how he arrived at a solution that allows you to create scripts from a stored procedure using SQL-DMO. If you get interested in DMO, we've got quite a bit of additional content here on the site to help you get going! Ryan is a new author here on the site, please take a minute to read his article, add a comment, maybe just say hello.
2003-05-02
17,095 reads
Copies the permissions from an existing database user to a new database user.Usage:exec copy_permissions_for_database 'From_User', 'To_User'* From_User must exist in the database.* To_User must not exist in the database.* To_User must exist as a login on the server.I used http://www.sqlservercentral.com/columnists/awarren/sqlpermissionspublicrole_2.asp as a starting point.
2003-04-14
1,874 reads
Like the replace function, but can replace more than 1 value at a time.e.g. select dbo.multiple_replace('hello', 'e', '1', default) gives 'h1llo'. Equivalent to: select replace('hello', 'e', '1')e.g. select dbo.multiple_replace('hello world', 'e;w;ld', '1;2;END', default) gives 'h1llo 2orEND'e.g. select dbo.multiple_replace('hello world', 'e$w$ld', '1$2$END', '$') gives 'h1llo 2orEND'
2002-05-09
443 reads
A user-defined function that returns a table of numbers between a and b (using the most efficient way I can think of).e.g. select * from table_of_numbers(1, 4) gives a table with rows 1, 2, 3 and 4.
2002-05-09
149 reads
By Steve Jones
As a part of the Book of Redgate, we have a series of (red,...
I recently had a new pipeline fail. It was actually a copy of an...
By Chris Yates
Microsoft Fabric is transforming real-time analytics for financial institutions. It provides a unified data...
This is one of those things very hard (for me)to explain in words. See...
Comments posted to this topic are about the item Feeling your age? How would...
Hi, one of my server configured with Standard_D64ds_v4 what is next level of version...
Can I rollback a cumulative update and remove it from my SQL Server instance?
See possible answers