The problem is that ampersand is a reserved symbol in XML. It is used as part of escape characters and if it is used as part of text...

There is no updated view. You can work with inserted and deleted view or with the update() function. You can read about it in BOL (Books On Line...

You can use the objectproperty function to check if the trigger is enabled. If you don’t mind getting it in few recordsets, you can also use the undocumented procedure...

In my opinion it is better to implement the paging in SQL Server. I don’t think that you’ll want the client to get 100000 records and then store them...

You can use Google for that. Just go to the search engine and type the key words (for example deploy ssis package sql server 2005). You'll get...

Change the user's default database to a database that exists on the server and is online.

Adi

In your code, you created one temporary table, but you are trying to get data from another 2 tables:

--Here you create table that is called #TempTrigger

select * into #TempTrigger from...

There is no need to use a cursor. You can use an update and insert statement directly on the tables. Here is a small demo that shows how...

Can you show what you tried to do? It seems to me that you need to get the current maximum value that exists in the table with select max...

Are you looking at the right place? I've had a case when someone told me that he can only see the database's files, but he can't see the database...

Did you try this query?

select name

from master.sys.master_files

where physical_name = 'RightFileWithFullPathHere'

Adi

You can enable the check constraint with the check option. Check the script bellow that shows it:

use tempdb

go

--creating the table with check constraint

create table demo (i int...

Very nice solution and a great explanation for the solution.

Adi

I hope that I understood what you want, but I have to admit that I’m not so sure. I understood that you want to get only the part of...

You can have a delete statement that is using top in it as Dave Ballantyne showed you. Then you can run it in a loop. Here is one...