Viewing 15 posts - 211 through 225 (of 1,248 total)
Do you have backup of master database?
If so, could you restore as other database and export/import data from there?
July 30, 2008 at 10:32 am
You have got to be carefull that no one share an account. Otherwise, your trial will be useless for someone who does it on purpose.
When you try to trace...
July 29, 2008 at 3:36 pm
Only database backups as DBAs. Networking team will take care network accesses. Windows administration team will take care of the stuff on OS level.
July 29, 2008 at 3:26 pm
Did you try sp_spaceused before and after reindexing?
I am not sure your statement of rebuildindex. Could you explain why the process release space?
Many thanks in advance.
July 29, 2008 at 3:23 pm
Did you check the configuration below?
EXEC sp_configure 'Ad Hoc Distributed Queries'
Also, I just feel the part below should be something else, such as the file name. Or there is something...
July 29, 2008 at 3:09 pm
Perry Whittle:
Thank you very much for providing hits.
After googling, I found the properties of NumberOfCores and NumberOfLogicalProcessors in using Win32_Processor Class.
I copied the script you provided as vbs file and...
July 29, 2008 at 1:12 pm
Check collation of this database.
SELECT DATABASEPROPERTYEX('yourDB', 'collation')
July 29, 2008 at 12:35 pm
By the way, whats wrong with my idea of getting the server tag/id and getting the info from the manufacturers website, thats what i do to find out info on...
July 29, 2008 at 12:29 pm
Perry Whittle:
I just ran your script. It did not provide the information on the core processors. The information the script retrieved is the same as the device manager.
Many thanks for...
July 29, 2008 at 12:14 pm
So far only did SQLServerLifer give a right direction.
Device Manager does not provide the number of core processors.
System Information from System Tools does not provide this information either.
I would like...
July 29, 2008 at 12:02 pm
If you would like to trigger the DTS utility from another site, you may need to grant your account the process administrators.
July 27, 2008 at 8:32 pm
You may try the command below,
sp_help_job
For more information about XP_SQLAGENT_ENUM_JOBS, the following link may help.
http://www.siccolo.com/Articles/SQLScripts/how-to-create-sql-to-sql-job-execution-status.html
July 27, 2008 at 8:24 pm
It seems that you are using ORACLE. If so, you had better post your questions to other column, Other Database(?), in this forum. You may get your answer more accurate...
July 27, 2008 at 5:15 pm
Viewing 15 posts - 211 through 225 (of 1,248 total)