The following is a brute-force method and should not be every day's practise. Can you detach the db? If so, detach it, rename or delete the log, attach the db. Make sure, you have a recent backup of the db first!Generally, if you don't backup the log, you cannot shrink it. Depending on your recovery […]
2005-03-18
Hi,I pretty new to SQL myself but I found a code snippet (maybe on this site) that helped alot and will solve your problem.Sub RemoveDBO() Dim tbl As TableDef For Each tbl In CurrentDb.TableDefs If Len(tbl.Connect) > 0 Then tbl.Name = Replace(tbl.Name, "dbo_", "") End If Next Set […]
2005-03-18
Supply a column list, for all columns excluding the identity column. Supply the matching column list in the Select. This is a best practice anyway, and is something you should always be doing.INSERT INTO tblFinal_inspection (Column1, Column2 ... ColumnN) SELECT Column1, Column2 ... ColumnN FROM tblFinal_inspection Where lotnum = @lotnum; In the above, replace "Column1, Column2 […]
2005-03-17
Age old problem, How do I get the ID for the thing I just wrote. @@Identity immediately after the insert works but you do need a return trip from the database. If the Database is not going to be Mammoth I suggest using a GUID you can create that on your client then just send […]
2005-03-11
You can configure transactional replication not to replicate delete actions.When you add the article to the publication, specify 'none' in the delete command stored procedure. @del_cmd = 'NONE 'parameter if you are using sp_AddArticle stored procedure, or from EM in the properties of the publication, in the articles tab and then in the commands tab.
2005-03-11
hi, could you give what you are really trying todo/ bassguy
2005-03-11
I created and viewed the .sql file. The instruction to delete the logs is in there. What I have discovered though was that the job has been reported as having failed. This would account for the fact that the files were not deleted.What is puzzling though is that the SQL log itself indicates the log files […]
2005-03-09
Allan,Take a look at this site - some good examples using variables.http://www.sqldts.com/default.aspx?107Darrell
2005-03-09
You might want to check out this page to verify that you are actually using Unicode http://mysecretbase.com/ColdFusion_and_Unicode.cfmAlso, storing a resume in a nvarchar column might be a tight fit. You can try ntext for more space.You also might want to research collations in the SQL Server manual. It may provide you with some key insight.Good luck.
2005-03-03
Here's the solutions that I finally arrived at...Select State, Company, Revenue FROM myTable A WHERE Revenue IN ( Select TOP 2 Revenue From myTable B WHERE B.State = A.State Order by Revenue DESC ) Order by State, Revenue DESC Thanks for the helpBrian
2005-03-01
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...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
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