SQL-DBA-01 (9/26/2016)

---

Hi Experts,

Wanted to know if there is there any way to have database names aliases in SQL Server?

For example, there is a database with Name: "database A". Can...

there's a neat trick using FOR XML to get a delimited list of columns.

here's a snippet i wrote that i use in a procedure to generate sample insert/update/merge statements.

it assumes...

First, use Central Management Servers or Registered Servers; that will be where you add new servers as you discover them.

That functionality is built into SQL Server Management Studio, so there's...

Besides running the script with an impersonated credential, which solves the SQL problem,i would think you need an explicit path to your sql file:

sqlcmd -S myserver -E -i "C:\Data\AutomatedScripts\DeleteRecordsTest.sql"

for a large script, you'll want to execute it via sqlcmd instead of trying to open it in SSMS and executing it.

did you try selecting from the temp table, and left joining the larger table?

from your description, it sounds like your first table is the larger table, and you inner join...

you are doing it correctly, but it depends on what is doing the presenting.

In Grid mode in Management Studio, CrLf are ignored(converted to spaces) FOR PRESENTATION ONLY, if you copy...

in general, If someone has sysadmin access, you cannot restrict access to...

when the view is actually compiled, the wild card is expanded to the list of actual column names in the compiled version of the view;that's to avoid dynamically having to...

there's a number of powershell scripts that use SMO to script out all objects as well;

you could easily set something up to call that on a regular basis.

I'll see if...

tobypaul509 (8/23/2016)

---

What is the best tool in terms of efficiency, cost and success rate for repairing and recovering corrupt SQL 2005 database files?

I need to purchase a tool for my...

ChrisM@Work (8/23/2016)

---

JasonClark (8/23/2016)

---

Try to run the below code to prevent accidental delete:

CREATE TRIGGER [TR_ProtectCriticalTables]

ON DATABASE

FOR

DROP_TABLE

AS

DECLARE @eventData XML,

@uname NVARCHAR(50),

...

doh simple and obvious;

the database_id =2 , regardless of what database context that...

whenever the difference between estimated rows and actual rows is off by a lot(order of magnitude or more,

it usually means the statistics are out of date enough to adversely affect...

it's an easy fix.

change the NOINIT TO INIT

that is append vs create/overwrite.

mwinn (8/11/2016)

---

I have been running this Backup script for several years but yesterday I had to transfer the database...