Monitor Server

Technical Article

Changing Multiple Databases Ownership to SA

  • Topic

I'm trying to develop a script in TSQL which employs sp_changedbowner to change all non system databases back to sa but am running into a problem with the 'Use" syntax to switch the database context that I'm in.Script I've been testing with follows:Anyone have any ideas to get around this?Thanks===============--create procedure ChgDbOwner as SET NOCOUNT […]


160 reads

Technical Article

RE: Client Network Utility data storage

  • Reply

It is in the registry:HKCU\HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\80\Tools\SQLEW\Registered Servers XIf you have a roaming profile you get the same servers on every machine.It is easiest to export from  current user, logged in as your colleague en import as yourself.  Otherwise you can export form HK_users\sid-colleagueOne possibility to get the sid is with psgetsid from http://www.sysinternals.comJoachim. 


Technical Article

RE: Decimal Format

  • Reply

How did you 'define' your decimal field? The proper syntax is: DECIMAL(p,s) p=precision - the number of digits total s=scale - number of digits to the right of the decimal. So, to be able to store your numbers 2.5, 3.125, 4.1275 you would need a decimal column as: DECIMAL(5,4) -SQLBill



Types of data consulting engagements and what you can expect from them


There are multiple ways organizations can engage with a data (DBA/analytics/data architect/ML/etc.) consultant. The...

Daily Coping 6 Dec 2022


Today’s coping tip is to find a new way to tell someone you appreciate...

What’s next: Job search burnout


I was given 4.5 months notice this past June and was fortunate to find...

Read the latest Blogs


Stairways to ScriptDOM Level 4 – Finding Nuanced Patterns

By Diligentdba 46159

Comments posted to this topic are about the item Stairways to ScriptDOM Level 4...

The Availability Group Secondary Connection

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Availability Group Secondary Connection

SSRS Expression Error

By Jeffs1977

I am getting the following error when I try to use the Expression below....

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers