Viewing 15 posts - 16 through 30 (of 906 total)
Any magic to port numbers being 50000?
July 29, 2009 at 2:08 pm
I agree with the Browser turned off only makes it a little harder for the hacker.
The only reason we are looking at multiple instances is because we have...
July 29, 2009 at 1:20 pm
I got it working years ago using this following syntax.
setup.exe /qb USERNAME="My Company Name" COMPANYNAME="My Company Name" PIDKEY= INSTALLSQLDIR="D:\Program Files\Microsoft SQL Server\" INSTALLSQLSHAREDDIR="D:\Program Files\Microsoft SQL Server\" INSTALLSQLDATADIR=F:\ ADDLOCAL=SQL_Engine,SQL_Data_Files,SQL_Replication,SQL_FullText,SQL_DTS INSTANCENAME=MSSQLSERVER SQLACCOUNT=domain\user...
July 21, 2009 at 5:45 pm
I modified you proc slightly to handle identifying the potential database by using plan attributes:
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROC [dbo].[dba_SearchCachedPlans]
@StringToSearchFor VARCHAR(255)
,@DBNAME VARchar(255) = ''
,@COUNT INT =...
June 14, 2009 at 3:49 pm
If you look at it as one big party, then yes you are right there is no ROI. But the way I look at it is its a great...
August 13, 2008 at 12:44 pm
No I didn't resolve it, and I moved on to other things. I was only working on this in a test environment,and trying to be proactive so I knew...
April 10, 2008 at 7:24 pm
Thanks for the input.
We are planning on using Linked Servers, but we do have a requirement to use windows authentication. Therefore we will be setting up deligation. We are probably...
April 30, 2007 at 11:20 am
You might want to consider creating a web service to query and return data.
April 30, 2007 at 8:24 am
Look up the "SELECT INTO" statement in BOL. Using SELECT INTO will create a table based on a select statement. Here is an example:
USE AdventureWorks;GOSELECT c.FirstName, c.LastName, e.Title, a.AddressLine1, a.City,...
April 30, 2007 at 8:22 am
I already read info at that site. It showed a similar notification but the value of the notification was "RESOURCE_MEMPHYSICAL_LOW" and the article says "From this record, you can deduce...
April 19, 2007 at 8:17 am
Humm, now that is a lot easier. Maybe I'll discuss going this route. Thanks for the thought.
March 1, 2007 at 3:00 am
Thanks for the information. I think the real issue here is a licensing issue, and not software. So I am planning on installing the Volume License version that does not...
March 1, 2007 at 1:30 am
I'm sorry I was not very clear in my post. What I meant was that a download of the Standard Edition edition was used for the install and an MSDN PIDKEY was used...
February 28, 2007 at 7:33 pm
I'm sorry I was not very clear in my post. What I meant was that a download of the Standard Edition edition was used for the install and an MSDN PIDKEY was used...
February 28, 2007 at 7:33 pm
Thank you that is what I thought.
January 22, 2007 at 8:58 pm
Viewing 15 posts - 16 through 30 (of 906 total)