I know I am probably prejudiced, but a properly designed database in MS SQL Server will likely perform as well as any other database engine. Based on the way...

Define optimum? In reality the optimum number is 1 user database and the 5 (including the resource database) system databases. As soon as you add a second database...

Doc,

The issue with the trigger you propose is that it assumes that every insert is a single row insert. This is a common mistake made in triggers. Triggers fire...

Just so you are aware "Adaptive Server Anywhere" is a Sybase product. What are the ODBC settings? Is there a firewall involved on either side of the VPN?

While this trigger would work it may not be the best way to handle the situation. First you have to define what you mean by last row inserted. ...

I don't think Hanshi's solution is correct. Could you supply some sample data along with the desired result? You may need to use a derived table or a...

planetmatt (10/7/2008)

---

MANU (10/6/2008)

---

Have you checked the default log file location where these files get created? Also, run select * from sys.traces and see under the path dispalyed in output of...

You would need to rebuild the relationships. They would remain pointing to the first table regardless of the name of the table.

I'd generate the drop and create scripts before...

The default trace has a trace id of 1 not 0. That is why you get no data from fn_trace_getinfo.

Manu is right check the path to the trace files....

Why do you have an "_" between the date and time? If you pass the string without the underscore and have the stored procedure parameter defined as datetime then...

Sure it is possible. You could use the information_schema and sys views.

There is currently no trust between domains. I can't even guarantee that the other locations even have a domain. All people sent out from the US office have...

Luke,

Thanks for the reply. Yeah if we were only deploying internally on the intranet we'd be all set. The issue is that the application will be accessed by...

Thanks for the replies guys. I read the per-processor license the same way you do Matt, but I've never really understood MS licensing which is the reason for the...

I agree with what has already been said. One thing I'd like to know is if there are separate production and development servers? If there are, you can...