Business Rules

Technical Article

RE: variable for DB name in sql script

  • Reply

Ah, those powerusers with their whole bunch of specialities... Well then, I don't know if you can reference a db with osql that doesn't already exist. I would use dynamic sql and I guess you the pitfalls, right? A very basic script for creating the db could look like declare @stmt nvarchar(1000) declare @dbname nvarchar(10) […]


1 reads

Technical Article

RE: Register same SQL Server more than once in EM

  • Reply

quote: Run cliconfg.exe from Start | Run. Create an alias to the server. Register the Alias in EM with the second set of credentials. K. Brian Kelley, GSEC Author: Start to Finish Guide to SQL Server Performance Monitoring Nice to know as well, Brian. Actually I was hoping to hunt you down on […]



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