What network libraries are the server listening to?

--

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

http://www.sql.nu

Basically, you need something like this to return rows 25001 to 50000:

select top 25000 * from table a

where pk > (select max(pk) from (select top 25000 pk from table order...

I think it should be like this:

exec xp_cmdshell'dir "D:\Program Files\" > d:\d_200304021.txt'

Of course, to be sure you could just open a prompt and run tyhe dir-command (or whatever command you...

Watch out for ident_current though, as it returns the latest identity-value on a table, from any connection. So if you're connection inserts a value, then a second connection inserts a...

Jeremy, you're absolutely right. However, depending on your needs you might actually want to roll back if this produces an error. Normally not of course, and in those cases you...

Yes, if you remove named pipes from the server netwrok protocols listened on then it is not possible to connect to it using named pipes. Not sure about local named...

You're right Mazi. Interesting. A rollback in a trigger rolls back all changes made in the transaction, even outside the trigger, and stops execution of any other statements following in...

quote:

---

A very useful article. I would just like to comment on the area of Page splits that was discussed. To get around...

quote:

---

Great article. One disadvantage to a clustered index that I hear a lot of people claim is disk space. How...

quote:

---

I really enjoyed reading this article - it was very well written, everything explained in simple but comprehensive terms - by the...

Sorry, you can't pass a table variable as a parameter to a stored procedure.

--

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

http://www.sql.nu

Omen, I agreee with you in that databases where 'invented' for integrating the data of an organization and to provide a centralized management of this data. However, one should not...

You could write the info needed to perform the 'stuff' to some log table, then have either a trigger on that table or some job perform whatever is needed based...

Check this link: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/instsql/in_overview_2xtf.asp

--

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

http://www.sql.nu

Simply installing SQL Server 2000 with the same data directory will not overwrite your user database aoc, but neither will it attach it so that you can use it in...