Viewing 14 posts - 1 through 15 (of 15 total)
The android "Data" from Star Trek.
Benjamin Lotter
http://BenjaminLotter.info/[/url]
http://www.LinkedIn.com/in/BenjaminLotter
Delight thyself also in the LORD and He shall give thee the desires of thine heart.
~Psalm 37:4
December 19, 2008 at 6:08 am
We have implemented an SQL Server instance inventory systems which consists of an SSIS polling mechanism and a centralized database repository. Among the many things we track on a...
Benjamin Lotter
http://BenjaminLotter.info/[/url]
http://www.LinkedIn.com/in/BenjaminLotter
Delight thyself also in the LORD and He shall give thee the desires of thine heart.
~Psalm 37:4
December 18, 2008 at 11:04 am
Phill Carter (12/11/2008)
Benjamin Lotter
http://BenjaminLotter.info/[/url]
http://www.LinkedIn.com/in/BenjaminLotter
Delight thyself also in the LORD and He shall give thee the desires of thine heart.
~Psalm 37:4
December 11, 2008 at 9:13 am
In cases where traffic to a SQL Server needs to be restricted to certain machines, I simply get with the network team and have them setup routing rules through the...
Benjamin Lotter
http://BenjaminLotter.info/[/url]
http://www.LinkedIn.com/in/BenjaminLotter
Delight thyself also in the LORD and He shall give thee the desires of thine heart.
~Psalm 37:4
December 4, 2008 at 8:10 am
dg (11/26/2008)
Grasshopper,The service is running. Even though I tried to install so that the instance is on my local machine, where do I check server accepts remote connections?
Thanks.
For SQL...
Benjamin Lotter
http://BenjaminLotter.info/[/url]
http://www.LinkedIn.com/in/BenjaminLotter
Delight thyself also in the LORD and He shall give thee the desires of thine heart.
~Psalm 37:4
November 26, 2008 at 2:52 pm
tosscrosby (11/26/2008)
Benjamin Lotter (11/26/2008)
Benjamin Lotter
http://BenjaminLotter.info/[/url]
http://www.LinkedIn.com/in/BenjaminLotter
Delight thyself also in the LORD and He shall give thee the desires of thine heart.
~Psalm 37:4
November 26, 2008 at 9:36 am
By default, when you install SQL, it adds the group "BUILTIN\Administrators" to the SQL Server with the sysadmin server role. The fact that get this error indicates that you...
Benjamin Lotter
http://BenjaminLotter.info/[/url]
http://www.LinkedIn.com/in/BenjaminLotter
Delight thyself also in the LORD and He shall give thee the desires of thine heart.
~Psalm 37:4
November 26, 2008 at 9:24 am
Can you provide more details? I've been using SQL Server 2008 for over a year now (since CTP5) and I have never had any problems connecting remotely.
Are you using...
Benjamin Lotter
http://BenjaminLotter.info/[/url]
http://www.LinkedIn.com/in/BenjaminLotter
Delight thyself also in the LORD and He shall give thee the desires of thine heart.
~Psalm 37:4
November 26, 2008 at 8:43 am
You should do this through a new database role that you create.
Here's a simplified example
USE A
CREATE ROLE db_executor
GRANT EXECUTE TO db_executor
Now add the role db_executor to the X user in...
Benjamin Lotter
http://BenjaminLotter.info/[/url]
http://www.LinkedIn.com/in/BenjaminLotter
Delight thyself also in the LORD and He shall give thee the desires of thine heart.
~Psalm 37:4
November 26, 2008 at 8:35 am
Here's another option but it would not be very practical in a development environment.
(1) Limit table access to stored procedures.
(2) Have the stored procedure perform the select and log to...
Benjamin Lotter
http://BenjaminLotter.info/[/url]
http://www.LinkedIn.com/in/BenjaminLotter
Delight thyself also in the LORD and He shall give thee the desires of thine heart.
~Psalm 37:4
November 26, 2008 at 8:29 am
Jamie Thompson has a clear example of this.
Benjamin Lotter
http://BenjaminLotter.info/[/url]
http://www.LinkedIn.com/in/BenjaminLotter
Delight thyself also in the LORD and He shall give thee the desires of thine heart.
~Psalm 37:4
November 26, 2008 at 6:57 am
Integration Services is shared and by it's default server connection is "." or in other words "localhost". The other components mentioned are installed on a per instance basis. ...
Benjamin Lotter
http://BenjaminLotter.info/[/url]
http://www.LinkedIn.com/in/BenjaminLotter
Delight thyself also in the LORD and He shall give thee the desires of thine heart.
~Psalm 37:4
November 26, 2008 at 6:09 am
I have accomplished this requirement by the following steps.
(1) Install a named instance and set it a static TCP port (under IP All). (for example, 4532)
(2) Configure a "default"...
Benjamin Lotter
http://BenjaminLotter.info/[/url]
http://www.LinkedIn.com/in/BenjaminLotter
Delight thyself also in the LORD and He shall give thee the desires of thine heart.
~Psalm 37:4
November 12, 2008 at 6:01 am
/*Here's how to change the owner of a maintenance plan to dbo in SQL Server 2005*/
--to find the name and owner of the maintenance plan
--select * from msdb.dbo.sysdtspackages90
--to find the...
Benjamin Lotter
http://BenjaminLotter.info/[/url]
http://www.LinkedIn.com/in/BenjaminLotter
Delight thyself also in the LORD and He shall give thee the desires of thine heart.
~Psalm 37:4
March 27, 2008 at 7:00 am
Viewing 14 posts - 1 through 15 (of 15 total)