I am sorry I do not have any. Havent touched Crystal in years. Used to be my main toy:)
welcome!
Check books online http://msdn.microsoft.com/en-us/library/ms187787.aspx or...
a full is a full. when the T-log fires it truncates the log when finished. It sounds like you kicked off the full first. then the full has everything...
duhh forget it.. I got it.
I can do the following: select char(64 + 2) = B select char(64 + 3) = C the result is B. I can put in a number and get the letter in that...
Any thoughts as to books to study for this certification? anyone done it yet? suggestions?
are you sure there are no native backups that were scheduled on the SQL side? could if be you are only aware of one type of backups while there were...
I got to throw in this to an old thread! It works and is all T-SQL. very nice. Just ensure you change the code IF @OSVersion = '5.2' to IF...
unfortunately it is SQL 2005 currently. It is being upgraded this year however! We did get a workaround and all is well. Thanks for the info!
I have a DB that has had dates stored in UTC by an application. My question is how do I convert a HISTORIC UTC date to reflect the datetime locally....
Good answer:)
you must have a query like this select * from table1 where id not in (select * from table2) it should only have 1 column in the subquery select....
Yeah Luis, its amazing the scripts we collect over the years, i had that one in my handy scripts directory already but good to have BEFORE your need...
Cool. thought so. Thanks Luis.
that is not your installation media...that is where you have installed it before. as it says, this is not a valid installation folder. normally...
Firstly, welcome to our forums! Your database is failure or the backup is failed? if the backup is failed it will indicate this in the database...
yes. the first item. later down the wizard you will be able to select what items you want to install. It can be the client tools without the...
got it..never mind.
I know I have done this before.. u know the feeling... but I cant recall.. I have a script that will create a bunch of commands. you could run...
Separate names with a comma.
