Hi,

Did you find what is causing this issue ? I am experiencing the same problem on a live server.

It happens randomly in different tables where cdc is enabled and to...

Running the create procedure inside a new windows works fine, but not through sp_executesql.

Any idea ?

Hi, thanks.

This is the message :

Msg 103, Level 15, State 4, Procedure PROC_V3N_VENTIL_ACTION, Line 49

The identifier that starts with ' SELECT DISTINCT vfd.id_da, vfd.site, pd.nom as pdnom, vfd.fan, i.id_personne,...

Hi, i'm trying this :

DECLARE @query nvarchar(max)

select @query = S.DEFINITION

from sys.all_sql_modules s

inner join dbo.sysobjects s2 on s2.id = s.object_id

where s2.name='PROC_V3N_VENTIL_ACTION'

exec sp_executesql @query

It's truncating the @query so i get a...

Hi SSC Journeyman, 😀

Maybe another approach could be partitionning your table.

Hope it helps. 😎

Hi YSLGuru, 😀

You can split backups over multiple files within SSMS or, if you already have a backup, split it with a compression tool like winzip, winrar, etc

Hope it helps....

Hi shahgols, 😀

I'm not an expert on Replication, but i'll try to give you an answer :

1) Yes, you can replicate some objects.

2) Not sure how to respond to this...

Hi sqlpadawan_1, 😀

For reporting purposes, i would recommend you to use log shipping if you need up to date data in your read-lony database. If having data from D-1 is...

Jeff Moden (10/20/2013)

---

jonysuise (10/20/2013)

---

Hi simonholzman 14059, and welcome to the forum 😀

To delete a large number of rows switch the recovery model of your database (in your development environment) to...

Hi paulmfinn, and welcome to the forum 😀

Personally, i recommend you to go for the MCSA 2012 certification path. It's pretty similar to SQL Server 2008 and your knowledge will...

Hi simonholzman 14059, and welcome to the forum 😀

To delete a large number of rows switch the recovery model of your database (in your development environment) to bulk-log, run your...

asranantha (10/19/2013)

---

Hi friends i have small doubt in sql server how to update nulls and empty values and replac other values in sql server

table data look like below

table :emp

id...

Jeff Moden (10/19/2013)

---

jonysuise (10/19/2013)

---

Jeff Moden (10/18/2013)

---

I would use just ISNULL AND NULLIF (like Sean did) because you...

Hi Balasach82,

An unsigned integer does not hold negative values. The value range is from 0 to the maximum of the datatype.

http://bi-architects.blogspot.fr/2011/12/ssis-datatypes-vs-sql-server-datatypes.html

Hope it helps.

Jeff Moden (10/18/2013)

---

I would use just ISNULL AND NULLIF (like Sean did) because you don't have unexpected...