Move End of Month file from source to destination
The script below executes on the first of every month and moves files from source to destination location.
2014-07-24 (first published: 2014-06-16)
941 reads
Scripts
2014-07-23 (first published: 2014-06-17)
1,759 reads
2014-07-22 (first published: 2014-05-16)
1,986 reads
Object dependencies in xml format
Most of the people know about the right-click option 'View Dependencies' in the SQL Management Studio.
It will diplay expandable tree off all dependencies each way. Correct me if I'm wrong, but I couldn't find any other way to save this othere than taking a screenshot of the window.
2014-07-21 (first published: 2014-05-19)
919 reads
Caching and paging a SQL Result Set
This is an example of how to Cache Query results on the Server side
then page though the results
2014-06-06 (first published: 2014-05-05)
2,241 reads
Start a job at a defined step on another sql instance
this is a powershell script that can start a job at a defined step name (default will be step 1), on a network instance either on a network on locally.
2014-06-04 (first published: 2014-05-05)
762 reads
2014-05-30 (first published: 2014-05-05)
1,448 reads
2014-05-28 (first published: 2014-05-02)
2,104 reads
Size of database files for an instance of SQL Server
Size of database files for an instance of SQL Server
2014-05-07 (first published: 2014-04-10)
1,308 reads
Find database where table is located
Return a list of databases which contain a table from wildcard table name.
2014-05-05 (first published: 2014-04-14)
1,178 reads
Blogs
A New Word: Ecstatic Shock
By Steve Jones
ecstatic shock – n. a surge of energy upon catching a glimpse from someone...
The CDO’s Playbook for AI Driven Decision Making
By Chris Yates
The New Arena of Leadership The role of the Chief Data Officer is no...
sp_snapshot – The easy way to take database snapshots of one or more databases – V3.0
Presenting you with an updated version of our sp_snapshot procedure, allowing you to easily...
Forums
Find Invalid Objects in SQL Server
Comments posted to this topic are about the item Find Invalid Objects in SQL...
Lessons from the Postmark-MCP Backdoor
Comments posted to this topic are about the item Lessons from the Postmark-MCP Backdoor
Question of the Day
Who am I?
If I want to track which login called a stored procedure and use the value in an audit, what function can I use to replace the xxx below?
create procedure AddNewCustomer
@customername varchar(200)
AS
BEGIN
DECLARE @added VARCHAR(100)
SELECT @added = xxx
IF @customername IS NOT NULL
INSERT dbo.Customer
(
CustomerName,
AddedBy
)
VALUES
(@customername, @added)
END See possible answers