I should have known somthing was up when I saw the selection list. I chose 2GB because there was no OS info in the question. SQL will support up to that limit out of the box on any server. There is a switch option to allow 3GB and that was what I was looking for. […]
2004-06-17
actualy i dont get that error anymore but all the buttons are disabled when i try to debbug.
2004-06-15
You don't need either LTRIM nor RTRIM nor SUBSTRING. All it takes is: SELECT @stringWithTab = REPLACE(@stringWithTab, CHAR(9), '') .. now @stringWithTab contains 'stringWithOutTab' PS. Invalid msg about substring is when the parameters gets negative. DS. /Kenneth
2004-05-06
As long as the users have no potentially destructive rights in the Master database how could Master as the default cause a problem? I just tried to open a table in the Master database and as expected got an error message. Using the ODBC DSN to point to the correct database is a lot more […]
2004-04-30
The bcp will be blocked by the insert/update locks. Try adding NOLOCK hint to the tables in testprocedure.
2004-04-08
I know this is an oft-discussed topic. My issue is that through all the MSDN articles, KB searchs, forum discussions, books, expert pontifications, etc. No one seems to really fully disclose how the Tlog actually works.For instance, I'm running a FULL recovery model on my databases. So I expect to see mammoth log files.But, depending […]
2004-03-25
Ah ok i understand now. Yeah the article unique id would be the only way i'd know to do it. Not that there isnt another one... i constantly see things i had no clue about posted on these forums.
2004-03-03
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2004-03-01
Yes! Now you can change history without notice.Isn't that brilliant?
2004-02-24
Ah come on Brian, schema changes are what makes replication "fun."
2004-02-18
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