that is not an error raised by SQL Server i think(the exclaimation point is the giveaway for me..no errors microsoft finds are worthy of exclaimation points

could it be that your procedures are doing SELECT * FROM SOMETABLE without a WHERE clause to limit your results? so you end up getting the whole table instead of...

i think the best encryption tools are the ones you own the source code for; as a result, i would lean towards using the tools available below before i would...

i searched for "strip function" and found this link:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=12594

Antarese686 contributed this function:

CREATE FUNCTION dbo.fn_StripAlpha (@val VARCHAR(8000))

RETURNS VARCHAR(8000)

AS

BEGIN

DECLARE @valout VARCHAR(8000)

DECLARE @pos INT

SET @pos = 0

SET @valout =...

ok here is the function and an example of how i use it; like i said, i use a calculated column for the sort order ;

also note that there is...

--As A cursor solution:

declare

 @fruitlist varchar(2000),

 @categ varchar(64)

 declare c1 cursor for select distinct category from #fruittable

 open c1

 fetch next from c1 into @categ

 While @@fetch_status <> -1

  begin

                set @fruitlist=''

  select  @fruitlist=@fruitlist +  isnull(name,'') + ',' ...

using your fruittable as a model, maybe something like this will help?

you'd still need to use a cursor, but just one cursor for each category; the code for within the...

i did something similar as well;in mine i assumed 4 sets like an ip address( it was actually version information, major/minor/revision andthe fourth param i can't remember right now) ,...

nowadays, some programs will install the desktop edition as their database, instead of access or some other system; i've heard that new dell systems have it preinstalled to hold some...

seen this many times; you can search SSC for "completely uninstall" or "manually uninstall" and find lots of info like this thread here:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=254290

i picked this script up from the forums a couple of months ago; it creates all the stements to move all indexesto a new file group:

I'm sorry i don't have...

if this were an internal only applicaiton, i might agree it would be no big deal to install an extra installation of SQL server, but if this is going to...

The name that goes in your connection string is SOMEMACHINNAME\INSTANCENAME;

I would ask this first: why must you create an additional instance, instead of using the default instance on the...

I think we need to see the table definitions; it looks to me like you have separate tables for ID, name and address;

at the very least the ID and NAME...

very simple:

update some_table set somecolumn=replace(somecolumn,'.txt','.csv')