Here is the correct syntax:

ALTER DATABASE Staging41 MODIFY FILEGROUP filegroup1 NAME = filegroup2

It is certainly not the same as the syntax of changing the file name.

To change the password try to use sp_password (see help for details on it).

It seems you want to modify the filegroup name but your statement is to modify the file name. Use MODIFY FILEGROUP instead. But if you are trying to modify the...

See, I would use TA_Id or something to shorten it even more. Some may say it is less descriptive and may confuse someone new to the code and database,...

David, taking your example, TrailerActivityHeaderId and TrailerActivityHeaderTrailerNumber are not the names I would vote for. I would not name a table TrailerActivityHeader but TrailerActivity instead (Header is implied). Then its...

Then just run two SELECT statements, insert both result sets into the same temp table (make the column match) and output it via another SELECT in the order of your...

It seems names like Id, Description, Name, etc. are typical in object-oriented programming. However they should be avoided in the database coding. Ideally every column (attribute in the logical design)...

One way to do it is to use a self-join, and if you had provided the script to create your data, I could give you the desired query. Anyway, it...

Greetings,

I agree that AccountId should be CHAR or VARCHAR (CHAR(8) seems right in your case).

If you need to group by the first two digits and keep AccountId as INT, you...

Thanks Jonathan. That would be too simple. It is currently set to about 18 hours but the process terminates with a timeout error after one hour anyway - very consistently.

These strange queries are all coming from one SQL Server database that was populated from AS/400.