Eugene Bereznuk


Technical Article

Grant permissions to a role

A very simple script that will first create a role (if it does not exist yet) and then grant full permissions on tables, views and stored procedures to the newly created role. Of course, you can add any filtering (i.e. grant permissions only for tables beginning with "abc") or grant partial permissions (SELECT or DELETE […]

You rated this post out of 5. Change rating

2002-09-26

1,089 reads

Technical Article

Random string and random number generators

The first part will create 2 stored procedures with self-explanatory names. The second is a standalone SQL that may be used in any stored procedure, script or DTS package.The generated string does not have any spaces and include only lower-case letters. To include anything else just change the boundaries for ASCII codes in the script.The […]

1 (1)

You rated this post out of 5. Change rating

2002-09-26

544 reads

Technical Article

Find circular references in single table

The objective is to find circular references in a single table related to itself. The script deals with a sample table Skills that have a SkilGUID (primary key) field and a SkilParentGUID field which is a foreign key to the record's parent from the same table. The number of levels in the hierarchy is not […]

3.67 (3)

You rated this post out of 5. Change rating

2002-09-24

1,027 reads

Blogs

Enable PowerShell Remoting

By

Enable PowerShell Remoting I use PowerShell quite a lot...

Get Configuration Change History From the SQL Server Error Logs

By

Get Configuration Change History From the SQL Server Error Logs There...

Read the latest Blogs

Forums

SSIS vs TSQL sp

By pozzolan

Hey All, I'm working on a new DW design and I'm learning DW on...

CXConsumer wait type issue

By saum70

hello, my query is select * into #TmpA from tblA (nolock). tblA contains 116000000...

How to speed up this?

By water490

Hi everyone One of my SSIS components seem to be very slow.  I am...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers