It is not an SPN number - SPN stands for Service Principal Name and is a DNS type of entry. You need to download and install the SetSPN utility...

Okay, now let's open the maintenance cleanup task and click on View T-SQL. Copy & paste that here and also into a query window. I would like to...

2 Tim 3:16 (8/4/2009)

---

I put this in a job and schedule it to run at SQL Server startup. I then get notified any time the node fails and what...

You don't by...

There is nothing in SQL Server that will tell you anything about the cluster specifically. Why do you need to be able to get this information from SQL Server...

I don't see the information from sys.indexes - but that is okay. What I do see is that you have a HEAP (object id 1215343394) that could be taking...

Can you run the following queries for me - and post the results?

Use {your database here};

SELECT * FROM sys.indexes;

SELECT * FROM sys.dm_db_index_physical_stats(db_id(), Null, Null, Null, 'DETAILED');

bpowers (8/3/2009)

---

That worked! I appreciate the help. I also read the forum etiquette document. How do I get my code to a window of its own like you two did?...

Lowell (8/3/2009)

---

shouldn't that be DBCC SHRINKDATABASE(N'YourDataBaseName' ) instead of shrinkfile? I'm thinking that if you deleted a lot of data, the space is reserved in the MDF, and not in...

Check the SPN records that were created - you probably need to remove the old ones and create new ones that point to the correct server instance.

ifila (8/3/2009)

---

I need to send a testDB to another country, so they may test a new project that was developed.

I dont want a direct connection to my server from another...

Where are you changing the password? Try using SQL Server Configuration Manager to change the password instead of the services applet.

Please review the article I link to in my signature to learn how to post your question and get better, faster answers.

To answer your question:

SELECT Id

...

ifila (8/3/2009)

---

What is the best method for sharing a DB.

I have reduced the size of the DB to 50 records, and compressed it, but it is still 4 GB !

I...

You still need to lock pages in memory for x64 systems. Grant that right to the service account and you will no longer get that message.