i don't know if this will help you;

i create my scripts in hierarchy order, so that items that depend on other items are created AFTER they are added to the...

aonther alternative: Narayana Vyas Kondreddi wrote a stored proc that you pass the table name and it creates all the INSERT INTO TABLENAME statements: note you cannot use this to...

does the new table have a lot of constraints on it? are the number of rows being moved in the millions?

could tempdb be expanding in size in 10mb increments...

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...