might want to check if certain tables are being specifically built on your secondary filegroup.

this should work:

SELECT DISTINCT

OBJECT_SCHEMA_NAME(ID) [SCHEMANAME]

,OBJECT_NAME(id) [TABLENAME]...

Ha,

I thought I was the only one that set people's default to tempdb.

everyone I run into gives me weird looks about it.

Cheers!

64 bit is best for consolidation projects where you plan on putting lots of DB's and/or SQL instances on one server to save licensing costs. If that doesn't make...

The best managers I had were conscientious, sought out expert knowledge, and wanted to succeed and lead. From your post it looks like you're on the right track if...

yes.

use SQL server config manager to bind an instance to a specific IP address and port 1433.

You'll obviously need to bind several IP's to your host's NIC to accomplish this.

you...

first off, do as Gail says. It will help greatly in the event that your query isn't covered by an index. We'll be able to help then.

Also, 13...

I did find this helpful tool for migrating RS objects around.

Haven't tested it yet:

http://www.sqldbatips.com/showarticle.asp?ID=62

Better try a Sybase forum.

We'll only tell you how to migrate from Sybase to SQL 😀

Sybase, Inc. should have some tools for you to actually move the database format from...

Man, that's a great question.

You can find out part of the answer in sys.sql_logins

As for whether or not SQL Server still considers the password expired if you stop checking for...

it's probably the account running SQL Server or Agent, or fulltext, etc.

I'm guessing someone changed the PW on the domain CUSTOMDIRECT, but probably not the password on your local service....

also check the SQL log for detailed messages around the restore and the steps that occur when the DB is brought online.

Cheers!

I just had this same error message on a similar setup.

3 quick things:

1. my primary issue is that there were packet drops on a storage switch.

You should...

what happens in SQL for you to get the error message:

Could not find procedure 'sp_procname'

it's always security, either you're specifying the wrong schema, or you don't have exec permission.

I'd...

One thing I forgot to mention was to make sure the login/user that's doing the inserts/updates/deletes has the default schema of dbo. That would also cause the issue because...

This problem is usually due to naming, either schema or replication procedure.

Are you 100% sure the names of the procedures specified in sysarticles of the publication databases matches the...