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')

you want to use the datediff function for this:

SELECT DATEDIFF(day, somedatecolumn, getdate()) AS no_of_days from sometable

SELECT * from sometable where DATEDIFF(day, somedatecolumn, getdate()) =3 --exactly 3 days old

SELECT * from...

 monster searches like this are bad, but sometimes you gotta do it:

I made an ugly server intensive cursor for a similar question a while back;noone came up with a...

you would not need to increase the size of the isql variable; that is just containing the command "sp_helptext your_long_procedure_name" ; i think the max size it could ever be...

ahh;

the subquery in the parenthesis needs an alias:

this fails: select name from (select name,id from sysobjects union select name,id from syscolumns)

this works:select name from (select name,id from sysobjects union...

because of the sum function, you have to GROUP BY in the outer select: try this syntax:

select sum(col1),col2 from

(select col1,col2 from table1 union select col1,col2 from table2)

GROUP BY COL2

your syntax is incorrect:

AND (src_terrier.Areacode LIKE @chr_div+ '%')

so if @chr_div = 'EV', the addition of the % sign makes the wild card search anything that STARTS with 'EV', like 'evansville'...

if the IN statement was running accross a bigger list, like  in(SELECT X FROM SOME TABLE),

I would expect it should be faster, because it would bailout as true on the...

i doubt it; most db servers are hidden behind the firewall at the hosting company, and only the web server can see the db server.

but that also means that you...

just missing the END command of the case statement: let me know how this seems to work now

 (CASE WHEN @PropertyValue BETWEEN 1 AND 10

  THEN @PropertyValue * 100000

  WHEN @PropertyValue...