I need somebody to explain how we do the maintenance in SQL server.Is it normal to run every night CHECKDB/CHECKTABLE? And why?Our new DBA runs DBCC CHECKDB/CHECKTABLE with auto-repair option checked and this is the reason he puts the SQL server in a single user mode from 10 pm to 5 am every day.This is […]
2004-07-30
2 reads
There are no dependencies across databases physically. You can write a procedure to "look for" the logical dependencies between databases, but that would be pretty hard unless you've really been consistent on how you name your foreign keys, column names, and tables.
2004-07-27
Trying check the permissions on the object using Enterprise manager, and see if anyone is denied access on the table
2004-07-16
I'm not sure I can manage all that in a single query, however a stored procedure would be straightforward enough: use statements like select top 1 where <, select top 1 where >, to find the lower and upper bracker, if they are the same return that, if one or both ends of the bracket […]
2004-07-16
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-07-16
Thanks for your help.lawprod is the owner of the table and UTR_Duplicate_REQ is a trigger as per sysobjects, so nothing is wrong in the syntax. Here is the script:CREATE TRIGGER UTR_Duplicate_REQ ON lawprod.REQHEADER FOR INSERT AS BEGINDECLARE @v_req_number VARCHAR(14), @v_l_index CHAR(4), @v_line_nbr INT, @v_atchnbr CHAR(2), @v_operator_id VARCHAR(10), @v_vendor VARCHAR(9), @v_ssn […]
2004-07-16
Thanks a lot for your advice! My solution is the folowing:I use Execute SQL Task from DTS and I execute Update statement against table. This way I always have only one record in a destination table, which is updated periodicaly.(without trigger ).Dima
2004-07-16
My sql mail is running terrible slow searched web for idea's nothing,does anyone have any advise that will work. It would be appreciated cheers
2004-07-01
3 reads
A mapped drive is only available to the user who creates it. SQL Server runs under the system account and the mapping is not recognised by the system account(unless it is a share). UNC means the fully qualified path i.e. \\servername\drive_letter$\directory Can you try the below sqlmaint -D Database -WriteHistory -VrfyBackup -BkUpMedia DISK -BkUpDB "\\servername\I$\DIRECTORY" […]
2004-06-30
here's one i use... (just a shade faster than Julian's method ) declare @clientId int select ClientId into #ClientList from ... while 1=1 begin select @clientId = min(ClientId) from #ClientList where ClientId > isnull(@clientId, -1) if @clientId is NULL break -- some code endhowever, using a cursor is sometimes more efficient than this method because […]
2004-06-25
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