Of course, nobody perform the restoration test in their production server. If you only test the method workable, How are you sure the backup set is restorable if some kind of disaster happens?
2003-06-26
Thanks for your input I realized the problem...I had to also include the Dbname.table.columnname in the where clause..
2003-06-26
1 reads
I tried it a again: use master exec xp_cmdshell 'bcp "select * from dbname.owner.table where checkbit = 0" queryout e:\products.txt -c -Sserver -Usa -Ppassword' I get as an error the format for writing bcp commands...?
2003-06-26
SQL Internal Datetime: datetime Date and time data from January 1, 1753 through December 31, 9999, to an accuracy of one three-hundredth of a second (equivalent to 3.33 milliseconds or 0.00333 seconds). Values are rounded to increments of .000, .003, or .007 seconds, as shown in the table. Example: Create Table Test(ColA datetime,COlB datetime) GO […]
2003-06-25
1 reads
No, in fact I don't think you will be able to insert them, unless you convert them into a single format. You are allow to store only one date format per column. When you query the table, you can give the date the format that you want. Another thing you can do is to create […]
2003-06-25
2 reads
Setting up a SQL Server Alert may help. In EM go to your server -> Management -> SQL Server Agent -> Alerts. Find the parameters that will satisfy your requirements.
2003-06-25
1 reads
quote: Intersting to see salaries of places like the US and especially Australia as they are places I am considering moving to...well when I have a bit more experience! Clive Strong I work in the financial industry, recently moved from the San Francisco Bay Area to Texas, still with same company. $78.5K/year which is ~ […]
2003-06-25
a5xo3z1 - Yeah, I wouldn't want to feed my family on what I'm making.... My wife is the breadwinner at this point... as I side note, I don't think I'll be in true database work for very long... I work for a small company and I have a feeling I'm going to end up as […]
2003-06-25
1 reads
Hi miked9999, sorry, a good starting point in MSDN is to look for IPM. From there you can jump to message class....According to MSDN IPM defines a message sent or received by humans while IPC classifies a message as sent or received by interprocess communication. quote: 1) send mail to not only smtp addresses (xx@xxx.com) […]
2003-06-25
1 reads
Hi there Its very simple, lookup BOL on "FOR XML" and have a careful read, the developers here use FOR XML RAW and whack it directly into the MS DOM for processing etc and passthrough to apply a style sheet to it. All works a treat. 4guysfromrolla is a good website for examples. Cheers Ck […]
2003-06-24
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers