Viewing 15 posts - 226 through 240 (of 789 total)
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 !!!
October 22, 2009 at 2:07 pm
Try to do it with linked server, simple link server B to the A and try to execute trigger referring the link server
October 22, 2009 at 1:48 pm
I'm curious what version of the SQL you are using ...!?
October 22, 2009 at 11:48 am
Try to use this application for SQL Backups and FTP transfering:
http://www.sqlbackupandftp.com/
:hehe:
October 22, 2009 at 11:42 am
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...
October 22, 2009 at 11:22 am
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...
October 22, 2009 at 10:51 am
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....
October 15, 2009 at 5:56 am
O O Too late, but I want to thank you Lynn that you post this article in SSC!
September 25, 2009 at 2:28 am
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...
September 22, 2009 at 5:16 am
As always Latest version of FireFox! Usually during the new posts, sometimes on replies so for reading is not problem!
September 22, 2009 at 12:29 am
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
September 18, 2009 at 6:01 am
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...
September 18, 2009 at 4:59 am
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....
September 18, 2009 at 4:04 am
When you use the CONVERT function try to not determine the number of characters during conversations
try like this CONVERT(VARCHAR, DATE_FIELD, format)!
September 18, 2009 at 3:57 am
Viewing 15 posts - 226 through 240 (of 789 total)