there are no loads on both the servers. we have isolated these servers. both the servers are not identical. the first statistics is from a 4 proc 4 gig server and the second is from 2 proc 2 gig server. since the powerful machine is slow, i am kinda clueless. all the indexes have been […]
2003-06-10
1 reads
ALTER PROCEDURE permissions default to members of the sysadmin fixed server role, and the db_owner and db_ddladmin fixed database roles, and the owner of the procedure, and are not transferable.
2003-06-10
1 reads
OK... this worked! I have a local Access staging table that I need to get to SQL Server. The ship date field may be left blank by the user in Access. I open a recordset from the local staging table and do the following: Do While Not rst.EOF If IsNull(rst.Fields("shipdate")) = True Then strSQL = […]
2003-06-05
1 reads
I'm not good with HTML, so I sent the pictures via email to you. Does this help? "Hope this isn't too big for your email, but I don't really know how to explain where this 'transform' option is. After you open the DTS wizard, you enter the connect info for the source and destination servers. […]
2003-05-28
1 reads
After much testing last night - we realized that the stored procedure called by vb works correctly under SQL 2000 Service Pack 2. The customer applied SQL 2000 Service Pack 3 and now the stored procedure is broken. Any ideas what might be happening? The error is listed in the first post.
2003-05-22
quote: With this strategy I could potentially loose 11 hours worth of data if a FULL backup becomes corrupt. Any suggestions on how I can overcome this? What if I perform X-Log backups every 15min? Can I use X-Log backups to brigde the gap between the LAST KNOW GOOD FULL backup and DIFF and the […]
2003-05-15
1 reads
If this is SQL 7 or 2k, you don't want to alias. That was a prior feature in v6.5. In 7 ro 2k you would probably want to give them the db_owner role. I keep tight control on this, if you tell us why we can guide you on whether you really need this. Steve […]
2003-05-14
2 reads
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
I recently received a complaint that Query Store for a particular database was turned...
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