No you dont have to specify an else to do nothing

declare @i int = 1

if @i = 0

begin

select 0

end

Will just result in a "Command(s) completed successfully" message as it has...

ssarria (11/27/2012)

---

Hi Pavan,

The idea is to create a back up of the database on a flat file. It could be by tables.though

I did use mysql workbench to update an existing...

Two ways,

Dont insert a value into the identity column of the destination

or

Add the below to the query

SET IDENTITY_INSERT tblTransactions ON

I believe the only way to do it is with the LOOKUP expression, so you will need to create two data sets in your report then use a lookup expression...

Column selectivity has a huge part to play in a statement as it tells the query optimiser what to do.

If you could follow the link in my signature on posting...

yes if the service is offline the files are not locked and can be deleted.

Now how active is the server?

Default trace will only store so much information before it rolls...

Yes I would as Gail has mentioned that the documentation on MSDN is incorrect, so anything which says its in seconds is incorrect.

Yes I would as Gail has mentioned that the documentation on MSDN is incorrect, so anything which says its in seconds is incorrect.

Yes, if the table already exists then add an INSERT INTO command below the CTE declaration above the SELECT.

If the table doesnt exist, add the INTO clause above the FROM.

WITH...

Yes, if the table already exists then add an INSERT INTO command below the CTE declaration above the SELECT.

If the table doesnt exist, add the INTO clause above the FROM.

WITH...

I stand corrected.

From MSDN

http://msdn.microsoft.com/en-us/library/ms188603(v=SQL.105).aspx

Simple recovery will mark the log as re-usable as soon as a checkpoint happens within the DB which will prevent the need for regular log backups and will stop the...

Please post error messages from the windows event viewer.

Read the memory management chapter in the Accidental DBA guide, link to the guide in my signature below.