124420294 (11/4/2016)

---

Hi,

Is it possible to combine VSS snapshot-based backup with transaction log backups?

Traditionally,people do native full backups, and do more frequent differential and log backups that can then be...

Trumped

You can't really...

Snargables, suggest you start a new thread on this, not many are...

This might come in handy then, SQL Server Data Tools 16.4[/url]

😎

This is well within the limits of using a script file, assuming that the actual data isn't too large and that the end customer can unzip the script file;-)

😎

Additions and...

Close all connections to the server and do the changes via sqlcmd, don't use SSMS

😎

The command is

EXEC sp_configure 'user connections', 32767;

Minnu (11/9/2016)

---

I have two tables

Dept table with 8 records

Logins table with 23 records

below query should display 31 records, but it is displaying 184 records (8*23=184).

i want below query to display...

If the database is small then my choice would be to provide scripts to create and populate the database.

😎

Question, will you at any stage have to update or refresh the...

sqlenthu 89358 (11/9/2016)

---

Hi Guys, I am working on an email alert to be sent to customers along with some information on monthly basis. The format of this mail should be...

You will have to use dynamic SQL, here is a quick example

😎

USE TEEST;

GO

SET NOCOUNT ON;

DECLARE @COL01 NVARCHAR(MAX) = N'COLUMN_01';

DECLARE @COL02 ...

You can use sp_changedbowner...

Sometimes I use this ad hoc method which is very simple but works like a charm

😎

First a staging table

IF OBJECT_ID(N'dbo.TBL_FLAT_FILE_IMPORT_STAGING') IS NULL

BEGIN

CREATE TABLE dbo.TBL_FLAT_FILE_IMPORT_STAGING

(

FFIS_ID ...

You are very welcome.

😎

Here is a brilliant article on the subject,...

Quick suggestion, unpivot the rows and apply the row_number with a partition on the ID

😎

USE TEEST;

GO

SET NOCOUNT ON;

IF OBJECT_ID(N'dbo.tblHierarchy') IS NOT NULL DROP TABLE dbo.tblHierarchy;

CREATE TABLE [dbo].[tblHierarchy](

[ID] [int] IDENTITY(1,1) NOT...