Viewing 15 posts - 91 through 105 (of 350 total)
IMO you are right- this is some kind of security issue. To understand where error happens (SSIS or sql job) run SSIS package first (I mean outside job) to be...
October 6, 2011 at 10:40 am
It depends on what you whould like to have in this report.
Just to remind that Job related info resides in msdb system DB, e.g. history- in sys.jobhistory system table, etc.
October 6, 2011 at 10:35 am
Probably you need to create this report (in required format) for 1 server (use msdb) and then loop through all your servers (use Linked Servers)
October 5, 2011 at 8:57 am
isuckatsql (10/4/2011)
I read in one of the MS technet forums, that you can put the Full text...
October 4, 2011 at 9:54 am
isuckatsql (10/4/2011)
Just to clarify, one server runs the main DB and a separate server...
October 4, 2011 at 8:15 am
krishna.vanne (9/28/2011)
I would like to know if we can make use of the reports the SQL Server has built inherently.
Can we generate the reports by some job and store...
October 3, 2011 at 11:21 am
It's not clear whether you would like to do this once or on regular basis.
Anyhow to share my experience- Run Sql Server Import and Export wizard and before Run save...
October 3, 2011 at 8:59 am
As far as I know it does not matter sorry what do you have but only what are you going to buy.
There http://www.microsoft.com/sqlserver/en/us/get-sql-server/how-to-buy.aspx you can probably find everything...
October 3, 2011 at 8:30 am
I am not sure you can do this without dynamic sql as CONTAINS predicate has single quote inside for this case:
CONTAINS(Description, ' FORMSOF (INFLECTIONAL, str_to_search) ');
With dynamic sql it works...
October 3, 2011 at 8:25 am
Difficult to say without seeing real query used
September 30, 2011 at 8:01 am
Not sure regarding 2K to 2K8 FTS catalog upgrade but from 2K5 to 2K8 catalog will be automatically rebuilt when you do Sql Server upgrade
(did this recently).
As far as 2K...
September 30, 2011 at 7:23 am
Target Server Memory presents upper memory limit sql server plans to use-
probably it (1,5GB) was assigned as Max server memory (configuration option).
But right now it (sql server) uses only...
September 29, 2011 at 10:56 am
sp_spaceused can help
September 29, 2011 at 10:37 am
sys.dm_os_buffer_descriptors DMV returns info regarding pages in buffer pool (or cache).
Your numbers show that right now for current load sql server need only ~0.5GB from available 1.5GB.
Check BOL on Memory...
September 29, 2011 at 10:31 am
Viewing 15 posts - 91 through 105 (of 350 total)