Viewing 15 posts - 25,486 through 25,500 (of 26,487 total)
>> BTW, you can't see when the procedure was last altered, but you can see "date created". So, for possible future searches when precisely it was last modified, DROP/CREATE gives...
September 18, 2007 at 7:41 am
I would join the lookup tables to the core table. Using a function in this case could cause a potential performance problem.
![]()
September 18, 2007 at 7:28 am
Yes. You would use SQL Mail. This requires a mapi client to be installed on the server (Outlook, not Outlook Express).
![]()
September 14, 2007 at 11:49 am
You shouldn't need a loop. Look at writing the query using group by.
September 14, 2007 at 11:33 am
Are you looking for something like this:
School1 #enrolled #InAttendance
?? ![]()
September 14, 2007 at 9:03 am
You can also find some more information on SSC regarding metaphone, just go to the SSC search page and search on metaphone. I checked all three boxes for the search...
September 13, 2007 at 1:36 pm
Leaves the database available for read-only access and so ou can apply future t-log backups.
![]()
September 12, 2007 at 5:25 pm
A full and differential backup is consistant as of the end of the backup. Both backup enough of the transaction log to ensure the consistancy of the backup for restore...
September 12, 2007 at 6:22 am
If you are doing a backup log with truncate only, then that tells me you are in bulk-logged or full recovery mode. You should be running scheduled transaction log backup...
September 9, 2007 at 10:41 pm
You will need to restart your restore from the beginning. This means overwriting what you have already done.
![]()
September 7, 2007 at 11:05 am
Yes, and I wish I had a better answer for you at this point.
![]()
September 4, 2007 at 6:10 pm
Are you sure that your destination has been properly shared?
![]()
September 4, 2007 at 6:10 pm
Instead of mapping a drive, try using a UNC (\\ServerName\Directory\[SubDirectory\...]filename). Be sure that the share permissions are set properly.
![]()
September 4, 2007 at 2:17 pm
Thank you Matt. I must be suffering from distractionitis, as I did not fully complete my thoughts in my earlier post.
![]()
September 4, 2007 at 2:14 pm
Viewing 15 posts - 25,486 through 25,500 (of 26,487 total)