I'm suprised noone mentioned the regular expression extended stored procedures:

http://www.sqlservercentral.com/columnists/mcoles/sql2000dbatoolkitpart2.asp

with that you can search, select or replace things patterns like this ; it's a bit easier than looping thru...

Ronald is right, in Enterprise Manager, it appears that you can edit an existing, but if you profile the database, you will see it is really dropping the constraint, and...

glad it helped, RSingh;

i was thinking along those same lines awaiting your reply...maybe some indexes are in the filegroup, but not the objects they index;

way to go!

the sql below might help; it identifies objects and the filegroup they belong to;maybe something is not moved off of the filegroup yet?

select sysobjects.name as TableName,

      s.groupname as Data_located_on_filegroup

just use the table to store the raw data, and use a VIEW to total up the information. if you try and store totals in the same row as the...

I took his question to mean if you created a datatable in vb.NET, then inserted data into it, how can you create the table on SQL server, and then insert...

if this is for oracle, here is a function in oracle syntax that returns the age:

CREATE

OR REPLACE FUNCTION

if you do not have SELECT privileges to the table, you cannot get the data into a temp table for manipulation.  there is no work around.

if you only have SELECT...

you could simply add the constraint to the table: you might need to update the table to the new value prior to adding the constraint

update mytable set myNewColumn=50 where MyNewColumn...

so why not do SELECT * INTO #TEMPGE_ReservesFile FROM GE_ReservesFile.then change the name in your update statments to the temp table just created: #TEMPGE_ReservesFile

why do you want to do it...

well...I assume that stopping and starting the services is a bandaid to resolve a memory leak or other performance issue...some effort should be put into investigating that;

as far as repeating...

i believe you can use a calculated column as well; here's an example that uses a function:

CREATE FUNCTION GetAge  (@BirthDate datetime, @CurrentDate datetime)

RETURNS int

AS

BEGIN

  return  year(@CurrentDate) - year(@BirthDate)

               ...

i typically use a Msflexgrid or a vsFlexGrid (3rd part component) in order to display data that exceeds 3K in records, because of the performance and record number limitations that...

SQLRep:

create a *.cmd file(notepad)  that contains these line items:

net stop mssqlserver

net start mssqlserver

net start SQLServerAgent

then go to Control Panel >>Scheduled Tasks for that file; then fiddle with...

it's actually pretty easy; you were almost there

SELECT u.username, SUM(h.hour)

FROM users u

JOIN hours h ON (u.username = h.username)

WHERE (h.entrydate BETWEEN getdate() -30 AND getdate()) OR h.entrydate is...