I'd just like to know how it is possible to "turn off transaction logging", like was mentioned in the Valentines Day scenario. I wasn't aware that this could be done other than during bulk load operations.Thanks,James
2004-09-17
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-09-17
Hi There,Could somebody help me with the following messages i have on my server?Error: 17833, Severity: 18, State: 1 2004-09-13 13:54:25.85 ods ListenOn connection '1433' is already in use..thanks!
2004-09-14
10 reads
I'm having some issues with remote procedure calls.ServerA and ServerB are both setup as linked servers. ServerA is SQL 2000/Windows 2000 and ServerB is SQL 2000/Windows 2003I can successfully run:exec ('[ServerA].master.dbo.xp_loginconfig') and alsoinsert into tblConfig exec ('[ServerA].master.dbo.xp_loginconfig')I can also run exec ('[ServerB].master.dbo.xp_loginconfig')The problem is when I run:insert into tblConfig exec ('[ServerB].master.dbo.xp_loginconfig')The process just hangs. What […]
2004-09-02
10 reads
Hello All,Situation:Current:I have a table with approx 450,000 rows and 88 columns. Only half the columns are in use (rest are for future use). I have no control of how the application spits out the data. I take the data and insert it into the current table (more or less of a storage table). There […]
2004-08-21
1 reads
Would "InvoerDatumTijd" have the same value for every row in the batch ? I have seen high-ratio keys cause problems in other databases, but I thought SQLServer handled it, maybe not. Make it nonclustered, and insert another column to make it more unique, eg (InvoerDatumTijd, LogID) If InvoerDatumTijd has few distinct values, it might not […]
2004-08-15
1 reads
Interesting idea. AFAIK, none of the site owners are bilinugal, so comments in any language are unreadabvle by us. I typically don't review the scripts when they are submitted because honestly I don't have time. I'm ok with other language comments, but they most likely mean the script may not be used by those that […]
2004-08-13
'...installed a new database (Sales)'? or installed new sql server. Is there a way to change the collation at the server level?
2004-05-27
Depends on what you want the front-end application to do....Crystal Reports is great for making reports and charts.-SQLBill
2004-05-27
We have been running Access as our choice of front end for some time, but still we run into limitations. What would be some options for a front end? Pros...cons...Brandon
2004-05-27
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