SQL job creation/modification/deletion auditing?
Mar 11, 2019 · Going forward, is there a way to be notified via email when jobs are created/modified/deleted in SQL 2005 Enterprise? Trigger maybe? I'm not having much …
How do you calculate the space required for snapshot
Sep 6, 2016 · There is no way your snapshot should be this large. For snapshots this large you should be using the initialize from backup option.
SQL Server 2008 install fails due to RegKeyCreate error …
Jan 7, 2013 · After installing and uninstalling SQL Server Express x64, I attempted to install SQL Server 2008 x64.
Read xml file into Sql Server 2008 - social.msdn.microsoft.com
Oct 7, 2021 · Hello, i have a file xml in path C:\test.xml and i want to read this file into sql server 2008, the file structure is similar to: <?xml version="1.0" encoding="UTF-8"?>
can I access function on remote server through linked server?
Dec 14, 2010 · Kalman Toth, SQL Server & Business Intelligence Training; SQL 2008 GRAND SLAM Proposed as answer byRanjith Kumar SMicrosoft employeeTuesday, April 6, 2010 4:45 …
Transactional Replication with Queued updating..
May 13, 2013 · I have setup the transitional replication Push with Immediate update mode , and now it failed because subscriber rebooted and now data was out of sync . Snapshot was not …
Using the in () parameter in a cte query
Nov 4, 2011 · The parameter is is a multi select and set as string. There are no nulls being sent through. As this is being passed through reporting services to a procedure on sql2005 and not …
Installing SQL Server 2012 alongside existing SQL Server 2008
Mar 26, 2012 · I have an existing SQL Server 2008 machine running on Windows Server 2008 R2. Can I install SQL 2012 on that machine as well without performing an upgrade?
function to test password complexity - social.msdn.microsoft.com
Feb 11, 2008 · I trying this I ran into the snak taht the "like" comparison on a case-insensitive SQL server did not enforce the contraint that the password contain both upper and lower case …
Event sequence column are missed when use profiler to save a …
Dec 2, 2009 · I use profiler (katmai version) to open a Yukon trace file, then store the trace file into a .xml file. When i open the .xml file, all events' sequence are 0!