Can you post the DDL statement you used to create the table [resut]?

Btw: your TRUNCATE statement is executed on the same database as your SELECT statement, because you didn't use...

From my experience most DBA don't execute a validation check after a copy action. From my knowledge a corruption won't occur frequently during the copy action. Most corruptions occur during...

Is this problem reproducable? Does it occur when the job is scheduled to run at a different moment? Are other processes running at the same moment (could cause blocking issues)?

By copying (backup)files from one location to another corruption can occur, allthough (most?/all?) copy commands have some kind of internal verification process.

But bottomline is: you can verify your backups by...

Define the columns in the SELECT part only by their name (not using the three part notation). When a column-name exists in multiple objects (tables, sub-query) of the FROM part...

tamer.h (1/8/2014)

---

Thank you ChrisM@Work

it works perfectly.

I'm now trying to copy the result of query to another table in another DB useing INSERT INTO but it always creating a new...

What datatypes and lengths are defined for the fields in the [MT_Store] table? Can you post the DDL statement of this table?

What is your default setting of "SET ANSI_WARNINGS" and...

p.avinash689 (1/6/2014)

---

Hi All,

I have a stored procedure like below.

USE [Mama]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER PROCEDURE [dbo].[IP_BILLNO](@BILLNO NUMERIC(10) OUTPUT)

AS

DECLARE @Y NUMERIC(4,0),

@d VARCHAR(12),

...

Run a profiler trace and log...

Take a look in the Activity Monitor in SSMS on the SQL Server at the moment the clients query seems to hang. Look at all the processes/queries that are executed...

So, what is your question or problem?

The code above does work well even with a space in the...

Default setup of maintenance plan is through a GUI. This will always have the risk of wrong manual input.

If you want to control the variables you need to build the...

Do you create your backups directly to disk, or are you writing to a backup-device? In this last mentioned situation the backup-device need to exist. You can query the existing...

It is rather hard to move the installed folder from SQL to another location. But it is much easier to move one or more databases to another disk.

In case of...

Make...