Logshipping is an option. Set it up, then when your ready to migrate, simply backup Server1's database logs with norecovery, and then restore that log on Server2 with recovery....

One option is dynamic sql, much like the below

declare @sql nvarchar(max), @age int, @id int

set @sql = '

select

*

from

test a

inner join

test1 b

on

a.id=b.module_id

where

a.id=@id

and...

You cannot compare a value to a null value, NULL is NULL and only ever NULL

What is NULL is it 0,1,2,3,4,5,'IDontKnowWhatIAm','ShouldIBeThisValueOf60834abc', so as there is no value it is excluded...

the N specifies that the following string is a NVARCHAR string

N'\\XXXXXXXX\W$\LOG_BACKUP\XXXXXXXX_tlog_201206072000.TRN'

Your actually backing up to \\XXXXXXXX\W$\LOG_BACKUP\, not the N drive

Edit

Mike beat me to it again

thats correct as you cannot compare a null value as the result comes back as unknown so is excluded from the result set

http://msdn.microsoft.com/en-us/library/ms191270%28v=sql.105%29.aspx

Revenant (6/7/2012)

"This must be a Thursday," said Arthur to himself, sinking...

Something like this perhaps

But without the table definitions and sample data like Gianluca has requested, we are clutching at straws.

with cte as

(

select

sub.SubCategoryId,

sub.SubCategoryName,

sub.CategoryId

,(select COUNT(1) from dbo.tblAdSpace where AdSpaceId in

(

select AdSpaceId...

Nope, there isn't a mark as answered on this site, the posts stay open incase someone else comes along with a better idea.

A CTE is a Common Table Expressrion, it acts like a temporary result set

Here is a link to MSDN http://msdn.microsoft.com/en-us/library/ms190766%28v=sql.105%29.aspx as they can describe it better.

If you have a volume licensing subscription you should have access to MS's download website, if not you will need to uninstall reporting services then reinstall it. Not just...

Not a problem, happy to help as always

you will have another problem whan you change to sharepoint mode, as you will need to create a brand new SSRS db as you cannot run a native mode database...

Looks like a case for row_number and a CTE, if I have undersood your requirements

DECLARE @SchDetail TABLE (dbSchCnt int identity(1,1), dbPatCnt int, dbSchTypeCnt int, dbSchDate datetime, dbSchStatus int)

INSERT INTO @SchDetail...

It might be down to rendering the report as I believe this is excluded from the execution time (I could be wrong). In VS it caches the data so...

govindarajan69 (6/8/2012)

I am also getting this error Error: 18456, Severity: 14, State: 8. + Login failed for user 'sa'. [CLIENT: 192.168.4.52], but the user is not accessing SQL Server directly....