Viewing 15 posts - 466 through 480 (of 1,478 total)
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...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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. ...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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,...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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,...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
June 22, 2011 at 8:08 am
http://lmgtfy.com/?q=clustered+index+vs+nonclustered+index
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 2, 2011 at 4:51 am
One more way
declare @String varchar(1000)
select @String='nhtinhfsgjsdereSalgjdmexSUM=1290SUMddssfsdfsdfsdsdsdf'
Select SUBSTRING(@String, 1, CHARINDEX('SUM',@String)-1),REVERSE(SUBSTRING(REVERSE(@String), 1, CHARINDEX('MUS',REVERSE(@String))-1))
select substring(@String,
charindex('SUM',@String)+len('SUM='),
charindex('SUM',@String,charindex('SUM',@String)+1)-charindex('SUM',@String)-len('SUM='))
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
April 26, 2011 at 5:02 am
Viewing 15 posts - 466 through 480 (of 1,478 total)