Quick solution, allows for variable length input

😎

;WITH SAMPLE_DATA(MOBILE) AS

(SELECT * FROM

(VALUES

('9334457582')

...

Here is my suggestion

Leave the identity to the destination table, don't use the identity_insert. Consider dropping the non clustered indexes and recreate them after the load. In addition, an SSIS...

Either re-run the command or check for SQLDUMPnnnn.txt file in the SQL Server Log directory.

One error is...

Another option if the sa login is not available is to run SSMS as Administrator and make the necessary changes.

😎

WhiteLotus (9/15/2014)

---

Eirikur Eiriksson (9/15/2014)

---

Quick question, by disabling it do you mean make it do nothing, make it disappear from the...

Quick question, by disabling it do you mean make it do nothing, make it disappear from the user's view or...

Quick questions:

1. Is...

nam.lenhat (9/14/2014)

---

Hello everyone,

I am using SQL 2014, but having problem :

When I use query in a table (having big data ..over one hundred million rows). I just query about...

Here is a quick example using a Tally/Numbers CTE

😎

USE tempdb;

GO

SET NOCOUNT ON

/* Generate a set of dates at a given interval

from the start date untill the end...

charipg (9/14/2014)

---

A. the user have enough/right permissions for the SSIS execution

B. No result , i mean no dbs showing as cdc enabled.

actually i checked your ...

Quick thought, do you have an example of the XML, depending on the complexity and structure one might find something that fits the purpose.

😎

You will find instructions here

😎

It tells the charindex where to start searching for the character.

😎

Hotel A146 10/25/2014 hotel...

123456789012345678901234567890

...

First, apologies for the piecemeal like answers:-)

From the top of my head, most likely causes:

A. Insufficient permissions for the SSIS execution user account, the "user" doesn't have enough/right permissions.

B. CDC...

Quick thought, when you pass the uniqueidentifier value to the procedure, you will have to pass it as a string, here is an example:

😎

USE tempdb;

GO

SET NOCOUNT ON

IF OBJECT_ID('dbo.SAMPLE_UNIQEID') IS NULL

BEGIN

CREATE...