Viewing 15 posts - 16 through 30 (of 135 total)
Hi
Think you need a third party software to do this,...
But if want to know by using some steps you can find the SQL server and its edition.
execute flowing.
select @@version...
Ali
MCTS SQL Server2k8
November 8, 2011 at 10:46 pm
I am also agreed with SQLRNNR and Mahesh:-)
Ali
MCTS SQL Server2k8
November 3, 2011 at 11:34 pm
Hi
File Indicants Log and data file, can you publish full script for more detail.;-)
Ali
MCTS SQL Server2k8
November 3, 2011 at 11:23 pm
Kim,
Can you enable and test with PCPIP. Why you are not using TCP IP?
Ali
MCTS SQL Server2k8
November 2, 2011 at 12:09 am
Can you post full defination of Both table?
😉
Ali
MCTS SQL Server2k8
October 24, 2011 at 12:16 am
Hi,
you can down load Express version free of coast as Ninja's_RGR'us said
and aditioonaly you can down load SSMS and If you don implementing any automation job AGENT is not needed.
Thanks
Ali
MCTS SQL Server2k8
October 19, 2011 at 1:27 am
Hi
You can visit for interview Q&A:
http://mumbaisqldba.wordpress.com/2010/12/25/sql-server-dba-interview-questions/[/url]
🙂
Ali
MCTS SQL Server2k8
October 19, 2011 at 1:09 am
Hi;
See my blog post.
http://mumbaisqldba.wordpress.com/2011/10/11/finding-out-how-much-memory-sql-server-is-utilizing/[/url]
Ali
MCTS SQL Server2k8
October 11, 2011 at 3:50 am
GilaMonster (10/10/2011)
Clustered index enforces the logical order of the data, not the physical.
hi gail;
I'm totaly confuse on this topics 'Physical or Logical' Please see the following link of MSDN:
http://msdn.microsoft.com/en-us/library/aa933131(v=sql.80).aspx
Can you...
Ali
MCTS SQL Server2k8
October 11, 2011 at 2:17 am
Hi
olaf.dedig And niravbhat
You both should Install and check on stand by box and be sure youe application is working fine.
That solved
Ali
MCTS SQL Server2k8
October 10, 2011 at 5:51 am
Fabrizio Faleni (10/10/2011)
The consequence is that there can only be...
Ali
MCTS SQL Server2k8
October 10, 2011 at 5:30 am
Hi;
Is this backup is OK?
From which version of SQL it was taken and Are sure you are storing on SQL 2k8 r2 sp1? is any other Version's Instase on Box?
Ali
MCTS SQL Server2k8
October 10, 2011 at 4:18 am
Aaron Ingold (10/3/2007)
First thing you have to understand is the difference between a clustered and nonclustered index. Clustered indexes...
Ali
MCTS SQL Server2k8
October 10, 2011 at 3:58 am
You may run this also
exec Sp_helplinkedserver
exec sp_helplinkedsrvlogin
Ali
MCTS SQL Server2k8
September 28, 2011 at 12:53 am
Hi,
As per my knowledge Rebuild is Offline operation, use reconfigure instead of rebuild.
Ali
MCTS SQL Server2k8
September 28, 2011 at 12:44 am
Viewing 15 posts - 16 through 30 (of 135 total)