sanjsharma (2/18/2010)

---

Im am trying to rewrite a vba Function into T-SQL

I have a math calculation in vba which correctly calculates

(1 - 1.5 * (0.11852 - 0.05478 * Log((3.00/ 10000)))...

terry.payne (2/18/2010)

---

All to often there are no messages at all and no specific entries to be found in the log files. The memory capacity of both the server and the...

Can you access remote folders on that server via windows Server? \\servername\foldername?

Is you app (sam) looking for an IP or hostname? Is the named pipes configured on the hosting sql...

any errors in SQL Logs?

I also want to know?

upgrade on sp_who3? which is an upgrade on sp_who2?

Create a SQL rdl report, where you can specify a more clean version of these sp's to return data in...

These should get you started and on the right track.

Ever thought about building a report?

Use master

Select @@VERSION

exec sp_helpDB

exec sp_helpuser

exec xp_fixeddrives

Use msdb

exec sp_help_jobhistory

exec sp_monitor

64 bit SQL will automatically see and possibly use all memory on the host.

The AWE can be enabled on 64bit SQL when you need pages to be locked in memory.

32...

How much memory do you need SQL to allocate?

How much memory is installed on your server?

Which version of SQL are you running? 2005, 2008? Express, Standard, Enterprise?

Need more info...

I used the MS Press book for 70-432, and must say it was very helpfull, thats why I'd prefer another MSP book for future exams.

Will have a look at...

Gail, Steve, taken from the MS site on 70-450...

Microsoft E-Learning

There is no Microsoft E-Learning training currently available.

Microsoft Press Books

There are no Microsoft Press books currently available...

http://msdn.microsoft.com/en-us/library/ms186358.aspx

Depends on the field of interest...

see: http://www.microsoft.com/learning/en/us/certification/cert-sql-server.aspx

Try a Copy Column task, or T-SQL Select into statement.

Personally I think 2gb RAM for SQL and an OS is a bit too little.

Did you specify the amount of RAM available to SQL?

You'll have to do a series of...