The first thing I noted was the way you were calling the stored procedure:

exec dbo.TableRowCopy 'appversie','id',2, @newid

the last parameter is an output parameter, so you should call it:

exec dbo.TableRowCopy 'appversie','id',2,...

M Chabot (3/13/2008)

---

Does anyone know of a place where the various encryption algorithms in SQL Server 2005 are compared? The books online says that the topic is out of scope...

Terry (3/14/2008)

---

Hello

If a have an index with field1 and field2, is it the same if a do a query:

select * from table where field1 = x and field2 = y

or...

This has been posted at http://www.sqlservercentral.com/Forums/Topic469394-149-1.aspx

Andras

jagpalsingh4 (3/14/2008)

---

Hi,

Plz tell me that in sql 2000 we use osql .And i just use this query to see all servers with this query ''osql -L''

but i m thinking...

John's solution is nice, because it is using the INFORMATION_SCHEMA views (part of the SQL Standard :), and is portable). But if you prefer SQL Server 2005 (and 2008) system...

Sandy (3/14/2008)

---

hey Andras,

------------------------------------------------------

Unfortunately on 2005 you cannot pass table variables to stored procedures as parameters. You will be able to do this on SQL Server 2008, but that is not...

The details are maintained in the log file....

dbcc traceon(3604)

dbcc log(1,1)

dbcc...

Sandy (3/14/2008)

---

Hi All,

I need to pass a table variable in a stored procedure.

Is it possible or not?

Actually, My web Page contains 100 records in Data Grid.

and I have to make...

Danny (3/12/2008)

---

I have always installed SQL Server (2000 and 2005) on the c drive of the server, and placed the data and log files on seperate disks.

Our network...

Steve Jones - Editor (3/11/2008)

---

Or urn Profiler, look for insert/udpate/delete stuff, save the file for a day and scroll through it at a meeting. Set your scroll to move slow...

Finally I got lucky enough 🙂

Andras

winston Smith (3/11/2008)

---

thanks for the reply. i am aware of log backups. the reason i am asking the question is because i want to have a strong case when i...

winston Smith (3/11/2008)

---

my company has a heavily transactional database. their backup procedure is a full backup once a week and a diff backup once daily.

This leaves a potential to lose...