Don't forget the thing about change control. It's better to work on that as well, so it is ready when you're done with the mapping. If not, it may be too tempting to go around it while waiting for it to become real, and before you know it, you might have to do the work […]
2005-01-19
or you could use this:select convert(varchar(12),getdate()) + right(convert(varchar,getdate(),126),len(convert(varchar,getdate(),126))-charindex('T',convert(varchar,getdate(),126)))result = Jan 19 2005 08:48:19.397 depending on your preferencing for displaying the date to your users. regards, Mark Baekdal http://www.dbghost.com+44 (0)208 241 1762 Database change management for SQL Server
2005-01-19
Thanks for responding. This almost works. When I insert this change the query does return a row for subscriptions which have no record in tSubsRoutes but it does not return a row where there is a record in tSubsRoutes that does not satisfy the condition (effective date <= today’s date). I may not have made it […]
2005-01-17
2005-01-17
It can be done to mark a table as a system object but that requires going out of your way to upset the sysobjects table manually or use sp_MS_marksystemobject procedure which is not documented.You should be able to delete and recreate these tables but there are issues trying to change it back to a user […]
2005-01-12
At the DB level you can use sp_helprotect. Therefore, if you automate the tying of login to user, you should be able to script something to go through each database and report back.
2005-01-11
Thank all of you for your replies. I ended up going the dynamic SQL route. The query was originally well over 8000 characters but was a UNION query. I busted up the query and it worked fine.Thanks again...
2005-01-11
Hi there.Well, I can't begin to try understanding what is going on, or the purpose of it all, however it seems like there's a lot of calculations, searched cases and stuff in there... Very briefly, I don't think that you can change the group by in any easy way... (At least not without further knowledge […]
2005-01-10
thanks a ton. I figured that was the case, but wanted to make sure i wasnt making stuff up.This is for a sox audit, and i had to either prove the settings were such and such, or show that there were no provings. I will be quoting you as a reference to what i guessed […]
2005-01-07
A table variable only exists during the run of the process that created it as is immediately destoryed at the end and any pages in tempdb associated with it are freed. Basically each time the procedure completes execution the object is immediately destroyed.So unless the stored procedures that create them are looping back on themselves […]
2005-01-06
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