Viewing 15 posts - 2,401 through 2,415 (of 3,233 total)
I don't have a detailed example, but you could just use the text document destination connection object and push your data to a working file. Then follow that up with...
February 23, 2007 at 4:14 pm
Wow, this thread has spanned time. Matt, can you forward me a copy to jrowan@cox.net? Thanks in advance. Great work.
February 23, 2007 at 4:03 pm
Go into EM, right-click on Databases, go to All Tasks>>Attach Database. You will then be able to browse out and find the MDF file. Use the Attach as box to...
February 23, 2007 at 10:59 am
Do you have a SQL Backup or a MDF file? If you have a MDF file with yesterdays date, where did it come from? If you truely have a MDF...
February 23, 2007 at 10:33 am
Ah, you do have a backup. You cannot selectively restore data so you'll need to restore the backup to a new database and copy the missing data over from...
February 23, 2007 at 9:55 am
I'm assuming you did not do this within a transaction either. Once you've deleted it, it's gone. You can purchase 3rd party software for viewing transaction logs, but I'm not...
February 23, 2007 at 9:14 am
ISDATE does recognize single digit months. Your descriptiong states that your accrued_thru_dt column is a datetime. I cannot reproduce your problem. Can you come up with a t-sql example to...
February 22, 2007 at 2:59 pm
If you are getting more rows than you expect with your OUTER JOIN, you have a one to many relationship between the two tables. If you only want one of...
February 20, 2007 at 3:49 pm
Ah, you are correct. It works fine in SQL Server 2005. I was working in SQL Server 2000 where this will not work. Sorry for the confusion.
February 15, 2007 at 4:39 pm
I don't think you can insert into a table variable using exec. You will need to insert into a table and select into your variables.
February 15, 2007 at 3:40 pm
As far as you table aliases go, keep in mind that the table and column aliases have scope in that the alias of t1 that you are using inside the...
February 13, 2007 at 12:28 pm
I would recommend not granting them access to the production server. If all of your developers are exporting data via DTS from your production server all day, what does that...
February 13, 2007 at 10:39 am
You cannot remove the identity property of a column. You must rebuild the table to do this. If you've done this via EM in the past, what EM does is...
February 13, 2007 at 10:27 am
Keep in mind Scott that there is more to a deadlock than simple lock compatibility. It is very important to understand lock compatibility within SQL Server, but there's more to...
February 13, 2007 at 9:54 am
Luke, I would have to disagree with you and say that this is not the long way; rather, this is the short way as many would feel inclined to use...
February 13, 2007 at 9:18 am
Viewing 15 posts - 2,401 through 2,415 (of 3,233 total)