You may try and write queries against sysprocesses, and if you can tie the username to an application you could perhaps sample the data over time, but this isn't foolproof....

A foreign key constraint, no. You'll have to use triggers to manage relational integrity.

K. Brian Kelley, GSEC

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring

http://www.netimpress.com/

The /3GB pushes drivers, etc., into an upper memory space and can limit the OS to only 1 GB of RAM. If your SQL Server needs that much, you can...

The old web server, was it in a trusted domain? Is the new one? If so, make sure you using the same domain account to run the web site (if...

Really the only way is by looking at the parameters and by examining the code itself. If you're just wondering about parameters, the object browser within Query Analyzer will show...

Try TextPad. There are a few others (everyone post your favorite time). These types of text editors don't open up the whole file initially, hence the reason they work.

http://www.textpad.com/

K. Brian...

Yes, the service account SQL Server runs under needs to have this privilege as Jonathan indicates. Also ensure you've configured SQL Server to be able to use AWE memory:

K. Brian Kelley
@kbriankelley
 

Provided there aren't any syntax issues (MySQL and Microsoft SQL Server doesn't have exactly the same SQL syntax but most of it is the same), you can isql or osql.

K....

If you're on Release 7, yes, this is exactly what it does. And it really slams the performance within the database as a result. If someone runs an HR211 screen,...

That's a possibility, yes.

K. Brian Kelley, GSEC

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring

http://www.netimpress.com/

Hence the question about Lawson version. For instance, the version of Lawson we're running with Employee self-service requires some 50 database connections to be maintained at all times. Reason? App...

Knowing and supporting Lawson like I have, Lawson's hooks could really be the determining factor here. How many connections, etc., Lawson maintains and how it accesses the data is very...

What version of Lawson Insight are you running?

K. Brian Kelley, GSEC

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring

http://www.netimpress.com/

Keep in mind the information schema views are there to meet SQL-92 compliance and provide metadata about the database structure. The "." means you have a two-part naming convention. As...

There are quite a few products out there that do parts of what you're looking for, but I'm not aware of anything that does the whole kit and kaboodle off...