The 'i' is simply the alias of the INSERTED table and

INSERTED & DELETED are also referred as magic tables in SQL SERVER.

I seen http://msdn.microsoft.com/en-us/library/bb522673.aspx and it is Reporting Services architecture diagram

Please visit

[/url]

Thanks

Manish

I tried to execute your update statement in SQL 2005 and '=<' is not working on that hence I modified to '<=' as follows.

Update TempTrans

set price=(case when relatedid is null...

Have a look

http://connectionstrings.com/

http://connectionstrings.com/sql-server-2008

Hi Michael Valentine Jones,

Just execute this following TSQL in query analyzer in your PROD and QA, and you will get the list of all the tables of that databse

...

Have a look

Source : http://blog.sqlauthority.com/2007/12/08/sql-server-generic-architecture-image/

Thanks

Manish

Have a look

Source : http://blog.sqlauthority.com/2007/12/08/sql-server-generic-architecture-image/

Thanks

Manish

Hi Vikas,

Yes, I am using Sql Server 2008 Version 10.0.1600.22

Hi Jeff

Thanks for the information, I will look for these.

How can i perform the same in SQLSERVER 2008, I got some errors like

"'FORFILES' is not recognized as an internal or external command,"

I am also having a small script to backup all my databases.....

Use Master

DECLARE @name VARCHAR(50) -- database name

DECLARE @path VARCHAR(256) -- path for backup files

DECLARE @fileName NVARCHAR(256) --...

Try this way...

1. Go To Reporting services Configuration Manager:

2. Navigate to "WebService URL" Tab on L.H.S.

3. Go to "Report Server Web Service URLs" section

4. click on the URLs: http://MachineName:portnumber/Reportserver

Yeah Rbarryyoung,

I did the same, hope I will get some clue, I will try once more tomorrow morning.

Hi SSCarpal Tunnel,

I tried the way as you mentioned the url

http://www.simple-talk.com/sql/sql-tools/using-powershell-to-generate-table-creation-scripts/

Thats very nice I am able to generate the script, but I am unable to get the primary keys...