You could easily write a DTS for this.

Jan

John,

You could replace them with char(13)

create table #test(test varchar(8000))

INSERT #test (test) VALUES ('This ' + char(13) + 'is a ' + char(13) + 'test' )

select * from #test

drop table #test

Jan

All,

This is the solution I implemented. It can probably be done more simple. I have one stored procedure that logs all security events. It runs when the server is started....

Wayne,

Thanks, but I do not understand it completely yet. From which query string?

The URL parameters are not part of a dataset. I tried to do this on your suggestion, and...

Indeed Brian, these are all great books.

But I also certainly want to mention the new books of Itzik Ben-Gan that are very good to get a deeper insight in the...

I believe it is a one-way encryption and this cannot be done.

Jan

You could do something like this:

SELECT field

FROM table

GROUP BY field

HAVING COUNT(field) > 1

Kishore,

You can use master..xp_fileexist. Problem with that is that is its return code. You might have to go for something like:

CREATE TABLE #fileexists ( exist int, dir int, parent int)

INSERT...

I'm experiencing the same error.

However, I have installed the certificate, and my IWAM_ has sufficient rights. Also, I'm not installing on a DC.

After installing, I get a message that I...

Isn't there a primary key in your table?

Can't you do something like:

UPDATE mytable t1

 SET name = newname

 FROM (SELECT TOP 5 t2.pk

  FROM mytable t2

   ORDER BY name)

 WHERE t1.pk = t2.pk

or use a...

DECLARE curDBs CURSOR

READ_ONLY

FOR select name from sysdatabases

DECLARE @name  varchar(40)

DECLARE @cmdstr varchar(8000)

SELECT  @cmdstr = ''

OPEN curDBs

FETCH NEXT FROM curDBs INTO @name

WHILE (@@fetch_status <> -1)

BEGIN

 IF (@@fetch_status <> -2)

 BEGIN

  EXEC master..xp_sprintf @cmdstr OUTPUT, 'select...

If your data is allready in a SQL server format, it is easy:

Hust copy the data on disk & use sp_attach_db

EXECUTE sp_attach_db @dbname    = N'test_db',

          @filename1 = N'c:\program files\microsoft sql...

Hi,

Concerning SQL2K, I once read in the reasource kit that it was possible to encrypt the .mdf & .ldf files on NTFS, and have the account that run the SQLServer...

Ilan,

It is not clear to me if this is a question or a solution you give us.

The only problem I have with xp_cmdShell MOVE & xp_cmdshell REN is that there...

Miguel,

When executing a trigger, you are in fact logically in a transaction. This means that there is a lock on at least one record of your table. You can check...