Server Configuration

Multiple processes have roughly the same logintime in sysprocesses
I have a .net 2.0 web application against SQL Server 2000. I was interested in peeking into the database and see the activities of this web application. So, I issued this following query in SQL Analyzer (pretty much like sp_who[2]): select spid, dbid, convert(varchar(30), login_time, 109) as logintime, sta... 30 Jun 2008 20:58

Object Explorer Details
In previous versions of SQL you could see the created date and time. In SQL 2005 you only see the created date. Is there a way to see the created time in SQL 2005? -- Thanks Titan ... 30 Jun 2008 14:48

deploying SSIS packages
I have an SSIS package which calls many other SSIS packages. Each of these was created with the import wizard in SSMS. As a result, they all have SourceConnectionOLEDB and DestinationConnectionOLEDB connections listed under the Connection Manager in the package designer. T deploy the packages to another server... 30 Jun 2008 16:52

MS-SQL computer ports
What ports do I need to open on the firewall in order to reach my ms-sql server from the outside? many thanks, Raul Rego NJPIES ... 30 Jun 2008 14:48

architecture for peak OLTP
Say you need to put up a database for a Big Deal website, that's going to get hit with a big peak load maybe once a month, like 50,000 transactions as near as simultaneously as you can handle. And the rest of the month, it may be ticking over a few dozen per second. Assume the transactions are comparatively simple... 2 Jul 2008 11:54

Restore .trn
Hi all, I would like to test that restorations are working from the .bak that is created each night and .trn files that are created every 6 hours. How do we go about it? I hear we may have to use a 3rd party application, but I'm open to suggestions. Thanks Chris ... 1 Jul 2008 12:20

Saving SP takes a long time....
Recently our SQL Server 2005 has started showing a strange behavior. Whenever you do an ALTER PROCEDURE to make changes to a stored procedure it can take 2 minutes or more to complete the operation. Any suggestions? -- Adam S ... 30 Jun 2008 12:44

stopping restore
Dear ALL, in SQL SERVER 2005 environmente how can I stop a restore? Regards Alberto ... 30 Jun 2008 12:44

Newbie - What's the default location of my database
I had an issue with a new Dell laptop running Vista and Dell says I have to do an Vista re-install. About a month ago I downloaded SQL Server Express 2005 and have been working on a local database. The thing is that Vista hasn't been allowing me to run Explorer.exe so I haven't so far succeeded in opening SQL Serve... 1 Jul 2008 07:12

Monogram Leopard Handbags - Louis Vuitton handbags
Monogram Leopard Handbags - Louis Vuitton handbags Luxury Gift : http://www.luxury-gift.org Louis Vuitton handbags : http://www.luxury-gift.org/Handbags/Louis-Vuitton-handbags.html Monogram Leopard Handbags : http://www.luxury-gift.org/Handbags/Monogram_Leopard_1.html Monogram Leopard Handbags series contain th... 30 Jun 2008 05:32