Not that I am aware of. There maybe a trick out there to do this. Anyways, you get an error message indicating the that subscription database is the...

dastagirid (10/20/2008)

---

hello ,

I am working on the Profiler and increase performance of

the queries.

"A QUERY IS...

Are you experiencing a specific problem or just creating a performance baseline?

Hey,

I had to do ths years ago. I took backups of all the databases, including the system databases and moved the backups to the new drive system.

I shut down...

I generally use BCP.

I do this quite a lot migrating client databases.

Hey Dave,

I have a little experience with MySQL. Basically my boss earlier in the year decided that everything should be migrated to MySQL and we should ditch SQL Server....

That will also work yes.

If you are concerned about the growth of your log file, then you need to look at the frequency of your log backups.

You could also look into importing the fresh data into a new table and updating table1 based on table2.

If that's not possible, then follow Jack's advice.

Are you taking backups of the transaction log before you attempt to shrink? If the log file contains data or has not hit a checkpoint, then the file would...

What exactly are you asking?

The result set doesn't match up to the query, so I'm a little confused.

Mark (10/7/2008)

---

select [Invoice No],

[Payment No],

[Payment Collected],

[Payment Date]

from TableB

where [Invoice...

Hi Adrian,

Yes it was. I still have no clue as to what is wrong with this. In the end, I used a different box for replication in order...

Do you have any free space on the drive where your log file sits? Is the log file set to autogrow or is there a maximum size?

Nice, no wonder I could not find the sysprocesses table. Tried seperating it to sys.processes.

No difference. The INTO argument is optional.