Sani,

i just opend the page

http://www.needanewpc.com/file_extentions.htm

and it says:

.glmDatafile (Glim)

Does it tell you anything? If not, are you sure it is a data file and not something like a Global...

Hello,

SQL Server usually tracks everything by user's SID (security ID). But not always, in particular cases it uses names.

See

Select * from syslogins

There is a long number under SID field....

Hi,

Did you try to open those files with Notepad? There should be some meaningful ASCI text. You say those files are from the old app. It could be that it...

I answered #1 incorrectly because I noticed the comma. The I ran #1 in Query Analyzer. It did not give me any errors and created a table test111.

I am running...

Marysa,

You need to understand who is running the job and give the appropriate permissions on objects or Windows permissions. For Example:

In Enterprise Manager that has a server registered using Windows...

David, thanks!

I like your script and will try to work with it. I will try to use schtasks. Do you know by the way where the job completion status is...

Deven,

Try this to at least get your data from the broken Master database. This advice does not carry any warranty and may not work. More over, follow it only on...

Does anyone have more detailed explanation on sp_spaceused then in BOL?

Run a query that will use sp_MSforeachDB stored procedure that will execute SQL statement for each database. The statement that you want to execute will be 'Select * from syspermissions'...

Something weird happened when I tested. I connected to my local SQL Server 2000 Personal Edition, copied and pasted a question, ran and it said

"The command(s) completed successfully."

I changed...

Sure!.

Since SQL Server has no way to know a part of what month you want to calculate, the part of 28 days or a part of 31 days, you have to tell it.

Get a...

Hi Michael,

You need to figure out who (what account) is trying to access the database. It could be ASPNET account, it could be your user Windows account anything. It depends on...

Hi,

I like the question. It made me look up once more the meaning of WITH TIES. I also like the  answer about dependencies

We had this problem today. We also tried to detach in 2005 and attach to 2000, did not work. Usually you can not downgrade the version, it is related to...

Run DBCC Checkdb on schedule or check database integrity as part of the maintenace plan. Do you still need to query  after you do that?