Thank You David,

i got more detail and better information from below link

http://ola.hallengren.com/

Thank u once again...:-):-):-)

Hi Thank you for your response,the error was gone but the the output "name" is coming from "set @sql='declare '+@var +' nvarchar(max) set '+@var+' = ''name'' print '+@var " not...

Hi,

After changing to nvarchar also same error...

Procedure expects parameter '@parameters' of type 'ntext/nchar/nvarchar'.

???

We tried using sp_executesql also, getting below error

Procedure expects parameter '@parameters' of type 'ntext/nchar/nvarchar'.

declare @var nvarchar(max) = '@var1',

@sql nvarchar(max)

declare @var1 nvarchar(max)

DECLARE @dbstatus varchar(500)

print @var

--set @sql='declare @var1 varchar(max) ...

Hi,

We tried this also, but variable "var1" is not retaining the value "name", print @var1 is returning NULL.

declare @var varchar(max) = '@var1',

@sql varchar(max)

declare @var1 varchar(max)

print @var

set @sql='declare '+@var+' varchar(max);set '+@var+'...

Physical size of my actual backup is showing :500 MB

Physical size of my snapshot is showing : 4 GB.

Is a snapshot will take that much size?

Please clarify...

Creating snapshot using below code...

create database Unify_snapshot on (

name = Unify_data,

filename = 'd:\Unify_Data\sn\Unify_snapshot.ss')

as snapshot of Unify;

and the fule "Unify_snapshot.ss" size is showing 4GB.

This is the first time i've created snapshot, i want to know that is snapshot size is more than the Database?

here my snapshot size is almost 8 times the database.

Please...

Hi Team,

I've created a snapshot for reporting purpose, is there any possible way to keep the snapshot upto date with the database,

Please suggest...

I agree with you, tuning the queries and indexes will help.

but please give one clarity...

is there any possibility that db_datareader can block queries...

Thank you for your response.

my query is perfectly tuned, but am a db_datareader user, my query is blocking another queries.

am not using NO Lock.

is there any best way to avoid...

Hi,

Thank you for Speedy response.

my question is, when i print the values from trigger

print @id

print @name

Print '--'

am getting

1

D

--

but as per my table id's 1 and 2 are updting, i...

Hi,

Gettting below error

The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.

is there any method to convert '-' to datetime,

in my scenario, if...

Hi,

Am having a non-cluster index on two columns, but the performance of that tables from my application is too slow, if i change the non-cluster index to cluster index, is...

Hi,

Definetely i'll get benefited if the data is sorted according to ID and empNo,

but my existing table contains primary key non cluster index, if i changed the same to primary...