Elliott W (9/23/2009)

---

Silverfox (9/23/2009)

---

charipg (9/23/2009)

---

If you have a SQL 2000 DTS package, can you execute the package in Query

Analyzer without having to use Enterprise Manager and without having to

right-click on...

J-983369 (9/23/2009)

---

Hi,

Yes the server name has changed. I have created a new link but the issue I have is some of the setting e.g. is_linked is 1 and is_remote_login_enabled...

J-983369 (9/23/2009)

---

Hi,

I have a linked setup where the name has changed. When I do a select * from sys.servers, I can see the name of the server but the...

You can...

try

DBCC FREESYSTEMCACHE ('TokenAndPermUserStore')

or if that doesnt work

you can use the same dbcc command with the ALL parameter

Should is the object word, you dont know what the job does or its dependencies

Sergey Vavinskiy (9/22/2009)

---

Silverfox (9/22/2009)

---

it is a best practise, we have 16 cpu machines here, tempdb is split, 1 mdf and 15 ndf. size has to be the same, I normally...

on a active active as already mentioned, the sql instances will have different port numbers, if you cannot set 1433 for that particuklar instance, chances are that the other instance...

luckysql.kinda (9/22/2009)

---

I need to give authentication/privilege to a user to run a job. I don't trust him. What are the minimum roles (server/database) should be given to a user to...

guptaajay1985 (9/23/2009)

---

I have the active active sql server cluster and I am not able to set the port 1433 for tcp ip.As I change it to Yes it is not...

Mark-459099 (9/22/2009)

---

this is my stored procedure:

ALTER PROCEDURE [dbo].[sp_NameSearch]

-- Add the parameters for the stored procedure here

@first varchar(max),

@race varchar(50)

AS

BEGIN

-- SET NOCOUNT ON added to prevent extra result sets from

-- interfering with...

Lynn Pettis (9/22/2009)

---

Silverfox (9/22/2009)

---

I like the article but just a minor point, the code doesnt work, maybe it is the way it came across when formatted.

You are missing a space,...

I like the article but just a minor point, the code doesnt work, maybe it is the way it came across when formatted.

You are missing a space, in your set...

http://www.sqlservercentral.com/Forums/Topic789066-83-1.aspx

Wouldnt have thought that there would have been more than one of you on these forums 😛

Pleased to hear it, I feel like I have achieved something today, well indirectly of course 😛