Viewing 15 posts - 841 through 855 (of 1,065 total)
I am thankful to all you for your valueable suggestions.
February 2, 2009 at 2:54 am
The original code that I posted is just a simplied sample.
The actual code could be some thing like this:
declare @query nvarchar(4000)
select @query = 'SELECT ColumnName FROM tbl_TableName WHERE ' +...
January 29, 2009 at 6:27 am
Also there are other ways of injecting attacks, without using ';' or '--', such as using HEX strings in the attack
Is this enough to take care of HEX...
January 29, 2009 at 6:02 am
Ping with server name.
See whether it returns same IP address.
December 31, 2008 at 1:34 am
if try to connect database using ip adress of that server it wont get connected but if i put the name of the server i.e abcd it gets connected but...
December 30, 2008 at 11:17 pm
Run ALTER INDEX command with SET (ALLOW_PAGE_LOCK = ON)
December 30, 2008 at 11:12 pm
I have a production db which is running on sql 2005 and I have a development/testing system which is in sql 2000
It is recommended to run same version on...
December 30, 2008 at 6:22 am
then i click next,next...
4) in specify disk backup directory , in remove files older than ( days) are not showing....
I think you are confusing the SQL Server 2005 UI...
December 30, 2008 at 12:53 am
The advantage of SQL Express is scaleability.
Later you can upgrade it easily to standard/enterprise edition and take advantage of features like Replication, Mirroring, Log Shipping, Clustering, Database Partioning, SSIS, SSRS,...
December 30, 2008 at 12:21 am
i don't know whether i need to run the "DBCC TRACEON (1204)" statement in the SQL profiler in query analyzer or in command prompt(To the to switch on the flag).
Query...
December 29, 2008 at 5:36 am
raymondpe (4/26/2008)
ok this worked for me..... just in case anyone has to do this:> RESTORE DATABASE master FROM DISK = 'C:\MINIDR\masterbackupfile.bak' WITH
RECOVERY, REPLACE;
2> GO
Problem solved.
Hi Raymond,
I had same problem...
December 28, 2008 at 12:52 am
Do you find the problom ? why the second request was not suppended by the first request?
I don't find any problem. The seconds request is blocked by the first...
December 26, 2008 at 4:22 am
This database is very critical for us,Could it be possible that after reindexing it will be not responding....?
No. Reindexing should not cause any problem.
December 26, 2008 at 4:07 am
use postnet
go
alter index all on TempLan_Details rebuild
December 26, 2008 at 12:39 am
Viewing 15 posts - 841 through 855 (of 1,065 total)