Viewing 15 posts - 6,196 through 6,210 (of 6,678 total)
Review the public role, maybe somebody set explicit deny rights on that role.
August 8, 2008 at 3:33 pm
I think this is what you are looking for: http://www.codeplex.com/sqldmvstats/
August 8, 2008 at 1:59 pm
How you pass parameters is based upon what the ODBC driver accepts. I do not know what Oracle expects, but you can try using '?'.
August 8, 2008 at 1:52 pm
Edwin (8/8/2008)
Our database environments are setup very unique.
SQL 2000 and 2005 are located...
August 8, 2008 at 1:47 pm
pfiricano (8/8/2008)
Here are results from the sp_helpdbcampus6 54123.25 MBsa7Jul 25 200880Status=ONLINE,
Updateability=READ_WRITE, UserAccess=MULTI_USER, Recovery=SIMPLE, Version=611, Collation=SQL_Latin1_General_CP1_CI_AS, SQLSortOrder=52, IsAutoShrink, IsAutoCreateStatistics, IsAutoUpdateStatistics, IsRecursiveTriggersEnabled, IsPublished
1D:\mssql\data\campus6.mdf PRIMARY55421184 KBUnlimited10%data only
2D:\mssql\data\campus6_log.ldfNULL1024 KBUnlimited10%log only
First,...
August 8, 2008 at 1:26 pm
rbarryyoung (8/8/2008)
usman.tanveer (8/8/2008)
does the "sort in temp DB" option of index effects sorting performance??
Yes, that's why it is there. However, I believe that this is only used when rebuilding...
August 8, 2008 at 12:43 pm
usman.tanveer (8/8/2008)
SELECT TOP 50
(SELECT TOP 1 Name FROM Product l INNER JOIN LicenseProduct lp on l.id = lp.currentproductid WHERE LicenseId = License.Id ORDER BY l.ReleaseNumber,...
August 8, 2008 at 12:32 pm
aminemaalal (8/7/2008)
-- 32 GB of memory-- 2 dual core processors
--/ 3 GB disabled
--PAE disabled
--AWE active.
By disabling PAE - SQL Server cannot use any more than...
August 7, 2008 at 2:31 pm
Did you set the min/max memory settings?
August 7, 2008 at 2:28 pm
Configure Database Mail and then lookup sp_send_dbmail in BOL.
August 5, 2008 at 4:31 pm
Just to clarify, you have a table that currently does not have a clustered index. You want to defragment the table.
If so, then you need to add a clustered...
August 5, 2008 at 4:17 pm
If you do a generic install and let the install setup and configure reporting services - all of that should have been created for you. If you didn't select...
August 5, 2008 at 4:06 pm
Go to the report you are trying to deploy, select the report properties and verify the selection there is pointing to the ReportServer and not Reports.
From a browser, navigate to:...
August 5, 2008 at 3:24 pm
rbarryyoung (8/5/2008)
Jeffrey Williams (8/5/2008)
You would do this:Execute sp_MS_marksystemobject sp_mytest;
And that should setup the procedure so it runs in the context of the database where it is executed.
Very nice, Jeffrey! ...
August 5, 2008 at 2:58 pm
Lee Hart (8/5/2008)
2. I did configure the domain account for the "Lock...
August 5, 2008 at 2:51 pm
Viewing 15 posts - 6,196 through 6,210 (of 6,678 total)