phillipalbertcox@googlemail.com

Are you on MSN Messenger?

Hi,

If you have access to CD's for SQL Server 2000 standard or ent, you may be able to build this way.

Thanks,

Phillip Cox

MCITP - DBAdmin

Ok, are your database configured for auto-growth and if so, what is the growth factor (e.g. 10% or 1GB)?

Hi,

More information is needed to understand why your DB has come-up suspect. Currently understanding is, you shutdown the server or SQL Server service and re-started the SQL Server Serive...

Hi Edwin,

Excellent result and appreciate update!

Thanks,

Phillip Cox

MCITP - DBAdmin

Excellent result!

Thanks,

Phillip Cox

MCITP - DBAdmin

Hi,

You will need to check you have enabled enabled MSDTC for network access using Component Services, as you're running a distributed transaction. Once in component services, goto the MSDTC...

Hi,

You can use the ISNULL function within your stored procedure(s) to check for nulls and replace if they exists or at the report level, but I would recommend doing this...

Hi,

Ok, this makes good sense, but what about the organizations that decide to go with a non-Microsoft operating system? This means, SQL Server wouldn't be able to compete with...

Hi Mike,

Ok, you're not gonna like this one, but seems you have exhausted all avenues for a resolution. So, if possible, let's eliminate the native SQL Server for restore...

Hi,

Have you enabled remote connections using the Surface Area Configuration tool? Also, check what ports your named instances are listening on using SQL Server Configuration Manager tool.

Thanks,

Phillip Cox

MCITP - DB...

Hi,

Overall, its really a team effort with the split being division of responsibility and each team member taking care of what they are skilled at doing well. This is...

Hi,

You can run on a separate server from source, which is the better option to minimize impact to your main server. Here is a good document for reference:

http://msdn2.microsoft.com/en-us/library/ms190389.aspx

Thanks,

Phillip Cox

MCITP...

Hey,

You already have an object in the database with the same name (e.g. sp_FindTableNames) and you can now alter or drop only. Maybe you executed the query more than...