Geeks With Blogs
mikedopp Geekswithblogs (edition) MSSQL There are 3 entries for the tag MSSQL
All Your Base Belong to SQL or Backup all your SQL Databases with one Query
Most of you would rather the the first title before or. Can't Remember where I got most of this script(if you know please send me a hate email) however I did some enhancements and I am reposting it. DECLARE @DBName varchar(255) DECLARE @DATABASES_Fetch int DECLARE DATABASES_CURSOR CURSOR FOR select DATABASE_NAME = db_name(s_mf.database_id) from sys.master_files s_mf where -- ONLINE s_mf.state = 0 -- Only look at databases to which we have access and has_dbaccess(db_name(s_mf.d... = 1 -- ......

Posted On Thursday, April 24, 2008 7:25 AM

MIX08-Using the Microsoft Sync Framework and FeedSync
Download Video FeedSync (Project) Astoria Offline (Project) Take Data offline? Alter Remote Offline Data and use FeedSync to update when connected. Reasons: App availability Network Utilization Lower costs Leverage client UI Leverage Service Extend for collaboration Flexible: Write a provider for Service Desktop Devices Protocols extensions Metadata Handles arbitrary topology peer to peer mesh and point to point Layers: End to End Solutions Ado.NET Sync Astoria Offline Protocol and Store Providers ......

Posted On Friday, March 7, 2008 5:55 PM

MSSQL 2000 Tip of the day
So I get this email. I forgot/lost the sa password. What to do? So I scrub the google database. Looking for an answer: Source Forgot or lost your sa password? Don't worry, there is a way out. Login to the SQL Server computer as the Administrator of that computer. Open Query Analyzer and connect to SQL Server using Windows NT authentication. Run sp_password as show below to reset the sa password: sp_password @new = 'will_never_forget_again', @loginame = 'sa' Technorati Tags: SQL 2000, MSSQL, Microsoft, ......

Posted On Monday, January 21, 2008 8:13 AM

Copyright © mikedopp | Powered by: