Mayank Khatri (5/23/2009)

---

I would just run the S.P in ur management studio or Query analyzer window with taking off create S.P from ur query and assigning the @year value to...

can you post the DDL for [HSI].[usp_RaguTest_Reports] ?

"##report" is a global temp table that seems to be missing.

A separate instance seems the way to go, since you cannot exclude sysadmins authority, unless you are willing to pay the price of encryption.

And even then it is just a...

Thank you for the feedback.

By default sqlserver has a \backup folder in its installation directories.

It is being pointed to if you make a backup using the GUI (SSMS)

(object explorer / right click on the...

There are some other options :

from within sqlserver these settings can influence the number of cpus a query can use:

/* show the current settings */

exec sp_configure 'affinity mask' ;

exec...

I cannot see why simply posting the code is an issue ??

The error states you are trying to implicitly convert a NTEXT column !

from Books online SQL2000

varchar[(n)]

Variable-length non-Unicode character data...

DNA is right on top of your issue !

Golden rule is:

- pre-size your files as accurate as you can (prefer having to much allocated !)

- if autogrowth is enabled ,...

Off course SQLServer will only use multiple cpus if possible and needed.

If someone issues a query stating 'option (maxdop 2)' it will only use max 2 cpus to resolve that...

kiran.chintala14 (5/20/2009)

---

I have a column of varchar(5000) in sqlserver but when i send the data of size more than 4000 characters as parameter to a procedure it is throwing...

TheSQLGuru (5/19/2009)

---

As an independent consultant (and knowing that you are newly so), let me paraphrase Robert Duvall in "Apocalypse Now": I love the smell of a train wreck in...

???????? :ermm:

You can add files of multiple disks to a filegroup, so disk size shouldn't be a problem.

Data will be spread over all files of the same filegroup (needs (clustering)...

I've seen udb sticks being used as sqlserver disk system for demonstartion purposes.

You know: a usb hub with 4 usb sticks on it, just to demonstarte hardware failure (pull out...

OP dated 04/2004 ?? 😉

another nice resource: http://sqlblog.com/blogs/paul_nielsen/archive/2009/05/09/why-use-stored-procedures.aspx

Post the procs DDL if your dev cannot find an optimal solution 😉

You'll have a good chance people over here will !