I don't think you can do this with the bcp command. You aren't running T-SQL here, you'd shelling out to a command prompt and then running a utility to pull...

for the change to take effect, the service must be restarted. Just like you need to log off for someone else to log on and use the same files on...

Check for triggers, get the execution plan, trace what happens. Post come code.

It can't be done, and you are not understanding what an NDF is. It's a file, and not necessarily consisting of one object.

You have to export/import the data from one...

Replication is by table. You can drop that article for the table and reinitialize just that table and article with a snapshot.

The export/import duplicates replication functionality. If you are...

Can you share any more details about how the argument went? I think it could help some others get XLS use reduced for some things.

Are you sure you can connecting with the same credentials?

Can you connect to other SQL 2000 servers with this machine and EM and see dbs?

http://www.sqlservercentral.com/articles/Security/updatedsqlinjection/2065/

http://support.microsoft.com/kb/897615

Restore the full, be sure that you use the 2nd tab with "norecovery" option set. Pick the file manually for the restore in the dialog.

Same for the diff.

Then the logs.

When...

It certainly won't solve all issues, but it could help. The supervisor/2nd person would still be responsible for their actions. If they let something through because they gave out their...

The column in the destination server that does not exist needs to have a default so it is populated by the insert statement.

blandry (8/26/2009)

---

When you go to these Microsoft "talks" Steve, do you ever ask the people giving those talks if they have done any research on the ideas they are presenting?...

Thanks, Hugo, for the practical applications. Didn't think about something like searching the newsgroups.

SQL Server doesn't really release memory to the OS, but it will replace the memory it uses with new data as needed.

It is possible that you need more memory....