Viewing 15 posts - 16 through 30 (of 153 total)
try using sqlcmd.exe as isql & osql are deprecated in SQL Server 2005
October 21, 2007 at 10:11 pm
Download performance dashboard from Microsoft website which will give you some more information about memory. use performance counter Total & Traget Server memory. i am not sure if DMV will...
October 21, 2007 at 10:06 pm
i think you have to take that resource out side group for any changes. any thing on fly will break the cluster.
From Old SAN Drive to NEW SAN Drive take...
October 20, 2007 at 9:35 pm
I think, if you run setup.exe for express edition it will prompt you to repair, modify or uninstall.
October 20, 2007 at 9:27 pm
check\verify in SQL Server Configuration Manager that client & Server protocol are configured correctly. Also at your surface are configration local & remote connection is enabled.
from sql server 2005 onwards...
October 20, 2007 at 9:22 pm
finally after doing test i was successfull to change DB Owner for Mirror DB.
My DB Mirror is setup for High Performance(No Witness)
For each DB, did following steps.
1> Backup DB on...
October 20, 2007 at 9:11 pm
In 64 bit hardware & software for SQL Server 2005 you do not need to setup AWE. MIN-MAX memory for SQL Server is used for Buffer pool so carefull measure...
October 20, 2007 at 8:58 pm
This are 2 options:-
(1) Visit following website
http://www.microsoft.com/sql/solutions/migration/oracle/default.mspx
Microsoft SQL Server Migration Assistant (SSMA) for Oracle is a free tool for migrating Oracle databases to Microsoft SQL Server 2005....
October 20, 2007 at 8:49 pm
switch /PAE only comes in to the role if your server as RAM above 16GB. If your Server as more than 16GB of RAM then you need to take out...
October 18, 2007 at 4:24 pm
You need to do some goggle for AS400 whether you need to install Driver on AS400 or does AS400 provides this driver. For e.g. Sybase we have to install ASE...
October 18, 2007 at 1:31 pm
i think in this query (SELECT * FROM LinkServer1...Customers WHERE CustNo = 'xxxx') you have to use full identifier\qualifier, dots in between LinkServer1...Customers will not help.
October 18, 2007 at 1:13 pm
if you do select on sys.syscacheobjects this will give you info about query plan, but besides that i think every thing is internal to Microsoft.
October 18, 2007 at 1:10 pm
from sql server 2005 every thing is Native SQL client & what you are looking for is it within Start---Admin tools---- ODBC Config. or are you trying to some DTS...
October 18, 2007 at 1:06 pm
/3GB switch as nothing to do with RAM. this /3GB switch is for VAS(Virtual Address Space) so by having this switch in boot.ini your kernel mode will get 1GB of...
October 18, 2007 at 1:03 pm
Viewing 15 posts - 16 through 30 (of 153 total)