Viewing 15 posts - 1,696 through 1,710 (of 2,496 total)
I agree, Hilary Cotter is one of the few sources of good FTS advice on the web.
April 1, 2008 at 7:31 am
Getting the most out of Full Text can be like walking in a wilderness without a map, compass or satnav. There are some details in BOL, and Google can...
April 1, 2008 at 3:11 am
If you give the SQL Agent service account Windows local administrator rights, you can bypass most security restrictions that might stop Agent from working. However, you are then running...
April 1, 2008 at 2:31 am
The reason it does not work is because you have made a mistake in your setup.
The credential you set up for xp_cmdshell must have a specific name: ##xp_cmdshell_proxy_account##. You...
April 1, 2008 at 2:20 am
The other idea about releasing a SQL Server with an integrated OS shuld be real. It would work, Oracle has already done this, and it would get SQL Server...
April 1, 2008 at 2:11 am
Any solution should be based around Jeff's suggestion. You should do the update as a series of transactions (explicit or implicit) so you are not locking too many rows...
March 27, 2008 at 3:33 am
You cannot install SQL Server 2000 on Vista.
You can install some editions of SQL Server 2005 on Vista - Express, Workgroup, Developer.
March 27, 2008 at 3:26 am
Vijay, you don't need to install the Reference document, just read it...
March 26, 2008 at 7:34 am
You need to look at SQL Agent Proxies. These allow non-sysadmin accounts to run SQL Agent jobs.
I suggest you download the SQLServerFineBuild Reference doc from Codeplex and look at...
March 26, 2008 at 4:14 am
If you already have a site standard SQL Server 2005 build, then probably that is what you should use.
If you are introducing SQL Server 2005 to your site, I see...
March 26, 2008 at 4:06 am
Going back to the OP, it is not possible to dedicate a given CPU to a given file or file group. In a multi-CPU or multi-core environment, there are...
March 25, 2008 at 4:28 am
Call Microsoft Support (PSS) and ask them these questions. I suspect they will recommend you build a new cluster on new hardware. As a minimum I suspect they...
March 25, 2008 at 4:17 am
I took a pot-shot at the answer, because all of them looked to be wrong. Needless to say the answer I chose was marked wrong...
It is not necessary to...
March 25, 2008 at 4:05 am
Any suggestions?
This is much a company procedure issue as a permissions issue.
Draft a note about prohibiting the restore of databases to C:, and get a high-level manager to...
March 25, 2008 at 3:26 am
Viewing 15 posts - 1,696 through 1,710 (of 2,496 total)