Get the defination of all table type in database
THis script will generate the Drop and create script for all user define table type
2014-04-18 (first published: 2014-03-25)
1,187 reads
Drop Table
RE: Trigger update is being overwritten
Can you post your TABLE DDL and TRIGGER for us to get an idea of what you are doing fully please?
2004-03-25
RE: Local system account vs Domain user
Executive is nothing but SQLServerAgent. If you are using distributed transactions (Calling the remote stored procs on some other SQL Server and Distributed updates) in your application you might want to start the DTC with same service account. Yes you must restart the SQL Service to take place this change not the Windows
2003-06-27
1 reads
RE: Need Help With Timed Stored Procedure!
It sounds like you have a good idea of the operations that need to be performed. So, for now we'll make the assumption you can code the stored procedure. To learn how to kick of a proc on a schedule, search SQL Server Books Online for the phrase: creating jobs. If you need some help […]
2003-06-26
Blogs
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers