Far as I know it is automatic ... SQL Server can be configured to give priority to Named Pipe or TCP/IP connections. If you disable Named Pipes, and the client...

Heh his been IT for 20+ years 😛 SO I call him old-timer LOL .. his just stuck in his ways :). We good buddies he actually listens; but...

Any development platform really ...

Web apps (.asp, .net, etc.)

Desktop (.net, vb, java, access)

What are you trying to do?

Mohit.

1 - When Restoring a SQL 2000 .BAK file to SQL 2008, is there a best practise regarding such things? Should the database be updated in anyway? or just put...

Try ...

SELECT FirstName, LastName, (SELECT TOP 1 BadgeID from Tabe2 AS T2 Where T2.PersonID = PersonID Order by validfrom desc) AS BadageID

FROM Table1

... Fixing small mistake on edit.

Mohit.

Hi,

Does you VB application use DSN? It is possible to configure those to use Named Pipes instead of TCP. SQL Server will communicate over either...

Same as, Link.

Something like this?

[font="Courier New"]CREATE TABLE #Temp (Col1 DATETIME, Col2 DATETIME)

INSERT INTO #Temp VALUES ('0:10:00', '3:15:00')

INSERT INTO #Temp VALUES ('0:10:00', '0:15:00')

INSERT INTO #Temp VALUES ('0:10:00', '1:15:00')

SELECT CONVERT(VARCHAR(8),Col1,108) AS StartTime,

       CONVERT(VARCHAR(8),Col2,108)...

To add to Michel ...

doing a delete from \\192.183.1.19\e$ is not good idea.

Instead i would create a new share and point it to the folder where you have...

I think these system db (master, msdb, model, and resourcedb) are all pre-packaged by Microsoft so they don't get created from scratch. The model db is used as a...

Good luck 🙂 And thanks for the update :D.

Hi,

I just got chance to look at these plans .. All were with the last part of the query because of the parameters passed in:

1) You need to...

Question is this SQL Server 2005? If it is running as your self fast but as developer maybe you are having issue with USERTSTORE_TOENPERM.

Check out: http://support.microsoft.com/kb/933564.

When you run it...

SELECT * .. should have created a shared lock on the table; not an exlusive one if you find the answer please let us know :pinch:. But even shared...

Since you are using 64-bit; awe settting does not apply to you. Now since I know that I strongly recommend you change it LOL. I seen a 64bit...