Viewing 15 posts - 736 through 750 (of 2,387 total)
Sure you can install MSDE as named instance.
setup.exe /qn /i sqlrun01.msi INSTANCENAME="MYMSDE" /l*v c:\msde2000_setup.log
December 22, 2003 at 2:05 pm
Found from BOL.
"If an index hint referring to multiple indexes is used on the fact table in a star join, SQL Server ignores the index hint and returns a warning...
December 22, 2003 at 12:33 pm
http://www.sqldts.com/default.aspx?292
Quoted from above article.
"Move or Rename File
This shows a simple file move operation, using hardcoded source and destination filenames. There is no explicit rename method in the scripting object, but...
December 22, 2003 at 11:50 am
quote:
One of my fellow coworkers detached the database, proceeded to restore the backup of the datafiles and then tried to reatach...
December 22, 2003 at 9:22 am
quote:
The problem is, that some of the fields in the Access DB have Validation Rules and Input masks setup. For instance,...
December 22, 2003 at 8:54 am
exec xp_cmdshell 'rename "\\tstsql01\d$\temp\ip.doc" "ipnew.doc"'
December 22, 2003 at 8:44 am
If your database was upgraded from 7.0 to 2000, read KB http://support.microsoft.com/default.aspx?scid=kb;en-us;298806&Product=sql
I would review server application/system logs for any possible errors which could cause the service restart.
In general, Access Violation...
December 19, 2003 at 5:22 pm
sqlspN.log in c:\winnt directory. N is the number.
December 19, 2003 at 5:11 pm
quote:
do you keep the free space enough to reorg your largesttable all the time?
December 19, 2003 at 5:01 pm
I agreed with jxflagg, It seems a network issue. Start perfmon to monitor network interface object on both fast and slow servers by rerun same statements.
December 18, 2003 at 2:04 pm
Use sp_procoption to set sp to autoexection runs every time SQL Server is started.
December 18, 2003 at 1:30 pm
I doubt "-SMS' here referring to SMS server. According to sp3 readme, The file Sms2kdef.bat is a batch file that starts an unattended setup using Systems Management Server. The command...
December 18, 2003 at 1:08 pm
quote:
I am writing a script for one of my users to run.
How is your...
December 18, 2003 at 12:47 pm
Have you run Performance Monitor to track the resource's usage in CPUs, Disk I/O, Network etc? What are counter numebrs if you had?
December 18, 2003 at 10:13 am
I must look into other question regarding to MSDE and post reply here. Sorry for that.
December 18, 2003 at 9:23 am
Viewing 15 posts - 736 through 750 (of 2,387 total)