Hi everyone,Hit me, kick me, abuse me whatever, but I gotta ask a silly question. If you DTS a database from one server to another but you want to call it different name on the second server (you create new database with different name while you are in the DTS process), would this cause any problem? Would the […]
2004-04-20
Hi,Try change Aritmethic abort setting from connection property.1. Run SQL Server Enterprise Manager2.right klick on server, select properties3.select connection tab4. check mark on ANSI warning,ANSI padding,ANSI nulls, Aritmethic abort
2004-04-14
First in my proc each column in the table that I want to select I have named as Mx where x is either 1,2,3,4,5 - for example M6. Then created this stored procedure to move backwards from the starting column of course a slight change can make it move forward as wellCREATE procedure myselect @smonth int […]
2004-04-10
THANKS much !!! (Yes, it isn't that large a database when you think about, compared to the others we have on this system it is one of the largest).Obviously I need to do a couple of practice restores on dummy databases to get this down.My big concern was after 3 hours, and having no gauge […]
2004-03-31
Sounds interesting...no doubt it will come with a performance penalty
2004-03-30
2004-03-20
2004-03-17
Hm, Jonathan, that reminds me of those quizes on TV where you have to tell your name, and if you're right, win $1,000.
2004-03-11
BOL article "Expanding Hierarchies" may help.
2004-02-24
Yes! Now you can change history without notice.Isn't that brilliant?
2004-02-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