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) […]

2003-12-18

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 http://www.truthsolutions.com/ Author: Start to Finish Guide to SQL Server Performance Monitoring http://www.netimpress.com/ Nice to know as well, Brian. Actually I was hoping to hunt you down on […]

2003-12-17

Blogs

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

By

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

Daily Coping 6 Dec 2022

By

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

What’s next: Job search burnout

By

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

Read the latest Blogs

Forums

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