Yea now everything is clear to me...so good experience if you try to work with both versions of SQL Server. I will try with export / import and scripting !!!

Try to do it with linked server, simple link server B to the A and try to execute trigger referring the link server

I'm curious what version of the SQL you are using ...!?

There are the screenshots:

http://www.sqlbackupandftp.com/screenshots/

Try to use this application for SQL Backups and FTP transfering:

http://www.sqlbackupandftp.com/

:hehe:

hmm interesting ...it depends from your storage that you have and sure from how many records that you have in your table ... example you will wait for a time...

Link info is useful, I will try with Export data or everything to script definitions and data...will try and I will see what happening ...

I know this fact but that...

Well I just saw it, and I can see that is posted 10/10/2009 so today is 15/10/2009 and I can see that there are 50 pages with questions and answers....

O O Too late, but I want to thank you Lynn that you post this article in SSC!

I mentioned that it happens sometimes not every time ....anyway it happens when you should post the reply immediately, and simple it doesn't work for the moment, then after 30...

As always Latest version of FireFox! Usually during the new posts, sometimes on replies so for reading is not problem!

Hmmm working with dates it works perfect so if we discus for any other converting you are right and I know that thing!

For more info about converting use this link

http://msdn.microsoft.com/en-us/library/aa226054%28SQL.80%29.aspx

Hmm wait a min;

SELECT * FROM Fiscal_Year

WHERE CONVERT (varchar(10),'2009-09-01 00:00:00.000', 112)

BETWEEN CONVERT(varchar(10), start_date,112) AND CONVERT(varchar(10),(end_date - 1),112)

SELECT * FROM Fiscal_Year

WHERE '2009-09-01 00:00:00.000'

BETWEEN start_date AND (end_date - 1)

'2009-09-01 00:00:00.000' - this...

Ok I post some topics but in general, try to find more info from BOL:

1. Backups

2. Disk Space

3. Job Failures

4. System Checks

5. Performance

6. Connectivity

7. Replication ( If you have )

-

8....

When you use the CONVERT function try to not determine the number of characters during conversations

try like this CONVERT(VARCHAR, DATE_FIELD, format)!