If you're on SQL Server Enterprise Edition (and Windows Advanced Server) and you have 4GB of RAM and the /3GB switch, the SQL Server will grab 3GB of RAM and...

That will work great if you are either running the .NET application on the server or wish to run the DTS package on the remote machine where the .NET app...

Couldn't you capture the trace to a SQL Server table and then search using T_SQL? You could capture the name of every Stored Procedure executed, and then look through those...

Remi, is there a better way than going back and modifying, testing, etc. ALL of those stored procedures? I can't think of another way to do this except for the...

You could also run a profiler trace and capture database activity to a table or file, then search it later.

In case you haven't already, I would check what account the SQL Server Agent job is executing under (Job Properties, Owner). If it is set to an account that has...

To add to the question...Has anyone applied the SP4 AWE hotfix (http://support.microsoft.com/default.aspx?kbid=899761)? Were there any problems with the hotfix or any other parts of the service pack?

TIA, chris.

There's an article here (http://www.sqldts.com/?225) on what files you have to copy to the machine that does not have SQL Server installed.

I've got a feeling that it is the same reasoning where MS doesn't allow ORDER BY in the view definition. They say to use ORDER BY clauses in the queries...

The advice that I had always heard i to not brng up slalry until they want to hire you. This is obviously more applicable when you aren't an internal candidate....

Best one I've read is Hitchhiker's Guide to SQL Server 2000 Reporting Services by Blackburn and Vaughn.

I doubt that Windows Authentication against a workgroup will work. You need to be authenticated against a NT domain or an AD.

From Books Online:

 'A user's network security attributes are...

I don't know about online tutorials, but if you are new to stored procedures, I'd definitely recommend a book, The Guru's Guide to Transact-SQL by Ken Henderson or another book like...

I'd like to see a study of how much time that professional people spend working (thinking about work, preparing a presentation, report, etc.) from home.

'You took ten minutes to book...

I shrink my files in small increments (1gb or 2GB) till I get a handle on how long it appears to take. I hate teat 'not responding' message too!