Viewing 15 posts - 466 through 480 (of 1,479 total)
The variables that are declared outside of the dynamic SQL are not recognized inside the dynamic SQL, so when you run the dynamic SQL and reference those variables, you get...
July 22, 2011 at 8:48 am
You can give permissions on specific objects, so what you can do is just give the user permissions to do select and delete on those tables. If you don’t...
July 22, 2011 at 7:43 am
Just a small correction to shaileshag2002’s code. The order by clause in the row_number function should be based on the column Date and not on the column Name. ...
July 20, 2011 at 2:00 am
Could it be that the scheduled job ran when you were already running a backup on the log? In any case I have to admit that I don’t understand...
July 14, 2011 at 2:34 am
Your criteria has to condition that approve_date should be greater then your calculated date. This means that the present date should also be returned. You need to add...
July 14, 2011 at 1:14 am
The message doesn’t seem to be generated from SQL Server. It has no error number and also the message itself doesn’t exist in sys.messages table. Could it be...
July 4, 2011 at 6:33 am
If I understand correctly, you are looking for a solution that will encrypt and decrypt the data, but won’t modify the data type and the table. If I’m correct,...
June 30, 2011 at 4:23 am
You can cast the numbers as string before encrypting them. Here is an example:
create table EncryptingDemo (EncryptedNumericNum varbinary(200))
go
declare @NumericNum numeric(10,5)
set @NumericNum = 12345.6789
insert into EncryptingDemo (EncryptedNumericNum)
values (EncryptByPassPhrase('This is just...
June 30, 2011 at 2:13 am
There is no table level encryption, but you can use column level encryption on more then one column in a table. If you want to encrypt the whole table,...
June 30, 2011 at 1:16 am
Your message is a bit confusing. You can’t backup the tempdb’s log, and there is no reason to do so. TempDB’s recovery model is simple and the server...
June 30, 2011 at 1:09 am
You have to rebuild the master. After that you can connect to the server and restore the master from your backup.
Adi
June 22, 2011 at 8:08 am
May 12, 2011 at 7:10 am
As far as I know, it won't let you detach the database if there are any open connections to it. You'll have to kill the processes before detaching the...
May 12, 2011 at 6:58 am
Indexes and tables are different objects and can reside on different file groups. In your case this is exactly what happened. You moved the noneclustered indexes to a...
May 2, 2011 at 5:01 am
It is needed if you also use differential backup and you don't want to add the new full backup to the chain (in other words you don't want the next...
May 2, 2011 at 4:51 am
Viewing 15 posts - 466 through 480 (of 1,479 total)