Start the Server Network Admin. Click TCP/IP and properties. Set desired port. Tell your proxy admin to open up port X (the port you chose), of course only for connects...

SET IDENTITY_INSERT tablename ON

INSERT INTO tablename .......

SET IDENTITY_INSERT tablename OFF

Note that only one table at a time (per session) can have IDENTITY_INSERT on.

Chris Hedgate @ Apptus Technologies (http://www.apptus.se)

quote:

---

I usually setup MSSQL and SQLAGent to run under a domain account that is a member of some global group so I...

Hmm...interesting. I totally forgot about my workstation running SQL Server 8.00.194 vs. my server 8.00.384 (although I did write it in one of the prior posts in this thread

I have two recommendations for you to solve this:

1) Add SET NOCOUNT xx statements to your procedure (maybe not necessary, but I would do it anyway) so that your procedure...

How are you executing the procedure from your VB application? If you aren't already doing it, use a command-object and like this:

cmd.Parameters.Append cmd.CreateParameter("@RETEmpID", adInteger, adParamOutput, 4, MyLongVariable)

cmd.Execute()

MyLongVariable = cmd.Parameters("@RETEmpID")

Chris Hedgate...

As default as I can see. Anything special you would look for? The server is a test server that I use to try stuff with (right now it's autorestarting the...

SELECT

u.[name]AS UserName

,o.[name]AS TableName

,c.[name]AS ColumnName

FROM syscolumns c

INNER JOIN sysobjects oON o.[Id] = c.[Id]

INNER JOIN sysusers u ON o.[uid] = u.[uid]

WHERE c.[status] & 128 = 128

Chris Hedgate @ Apptus Technologies (

OK, I've continued testing this and I've come up with the following:

The solution Leon presented works great. I kill the service (using either the kill utility or by ending the...

OK, what I was asking about is the supposed feature of SQL Server Agent to restart itself if it is unexpectedly stopped. To see what I mean, right-click SQL Server...

quote:

---

Can you guys guide me How much more memory should I get? I'm running only SQL Server on the box.

---

SET QUOTED_IDENTIFIER ON

GO

Chris Hedgate @ Apptus Technologies (http://www.apptus.se)

OK. Guess I'll have to look through the CDs then.. It's in there somewhere.

Chris Hedgate @ Apptus Technologies (http://www.apptus.se)

Andy, do you have a URL for this tool (MS Load Simulator)?

Chris Hedgate @ Apptus Technologies (http://www.apptus.se)

OK, that's what I thought. My script starts by importing the last trace file created, and then starts a new trace that runs for 5 minutes and then quits by...