First

Start -> Programs -> Microsoft SQL Server 2005 -> Configuration Tools -> SQL Server Configuration Tools

Then

SQL Server Network Configuration -> Protocols for MSSQLSERVER

Restart the SQL Server Service. If you are...

Hi

I would start with the DELETion of removed data. After that use an UPDATE with OUTPUT to update the existing data and remember their ids. At last you can use...

Ensure that you are calling your procedure on correct database (check connection string).

Since you are using VB; avoid any "On Error Resume Next"/"On Error GoTo 0". Check if you get...

I'm not sure if a temp table is the correct way to go in this case. It will be removed immediately after your batch file disconnects from database.

I would use...

WayneS (6/4/2009)

---

For a small list, use the Numbers / Tally table method.

For a large list, use XML. See my article[/url] that covers this. It even includes a comparison to the...

Be careful with master.sys.fn_varbintohexstr. It is a undocumented function and MS changed in SSE2k8 (return value becomes VARCHAR(MAX)). It might be changed/renamed/removed in future versions.

PRINT 'Hello

World'

Hi

Could you explain more detailed why you are looking for an object oriented database? Why SQL Server?

Flo

As Jack already wrote. If you work with batches you should have a look for SSIS or bcp. Import the complete batch into staging tables. After this you are able...

The answer for the correct technology depends on the executing process.

If this should be done by a DBA/Maintenance job on server I would advice xp_cmdshell because it is an available...

I'm glad that I could help! 🙂

Hi Lynn

Lynn Pettis (6/1/2009)

---

You may have read my post late last week looking for help, not with SQL Server, but trying to help my daughter who is currently in...

Jack,

Would a "Person_Unit_Relationships_Hist" table be an option? You keeps you main table very small and you are still able to get historic information. Since your table is a many to...

Works fine on my system. Did you execute the complete script (including the IF EXISTS -> DROP)?

I copied the procedure and changed the SELECT to an existing table in my...

Jeff and the meat...

LOL!