Using MS SQL Server

Script Task with SSIS
I added a script task to my ssis package to check last file modified in Explorer. Here's the code: Public Sub Main() Dim fi As System.IO.FileInfo Dim ModifiedTime As DateTime If CInt(Dts.Variables.Contains("User::FileUpdatedActual")) = 1 Then fi = New System.IO.FileIn... 6 Apr 2010 11:53

need to establish sound backup/maintenace/security practices
We are s/w development company with a number of installations that use SQL Server. We are looking for a qualified individual who will help us establish good db security, backup and maintenance procedures and practices for our production sites. We are located in Los Angeles, CA, local contact would be much preferred... 30 Mar 2010 17:13

here is the way to increase the required
SQL Server 2000 - To access the SQL Server Agent Job History in Enterprise Manager, navigate to: Root SQL Server Instance Management SQL Server Agent Right click on SQL Server Agent Select the 'Properties' option Select the 'Job System' tab In SQL Server 2000, it is possible to permit automatic deletions... 7 Apr 2010 10:03

Location Intelligence demo
Quick demo on the power of Location Intelligence to visualise your data http://www.youtube.com/watch?v=uhD1NtNdj8E ... 30 Mar 2010 08:18

SQL 2000 SERVER - BIG PROBLEM WITH BIG DATABASE :-(
You can set Autoshrink by using following system stored procedure. Exec Sp_dboption 'Tempdb', 'Autoshrink', 'True' From http://www.developmentnow.com/g/95_2004_3_0_0_378026/SQL-2000-SERVER--BIG-PROBLEM-WITH-BIG-DATABASE-.htm Posted via DevelopmentNow.com Groups http://www.developmentnow.com/g/ ... 27 Mar 2010 09:32

728814 Reserch anything, nerw content up to date all sites 81
I fell in love with the net and all the compuiter teahcnology in the very early years and have loved it ever since, I have an IT Degree and Communications degree and will be working on my doctorate for the next five years, in bwetween I design websites, databases, Multimedia Produxction or anything that wil make me a p... 22 Mar 2010 22:59

Replicating from SQL 2000 to SQL 2008
I have 2 instance of SQL Servers. Instance A : SQL Server 2000 Enterprise Edition running on Windows 2003 (32 Bit). Instance B : SQL Server 2008 Enterprise Edition running on Windows 2008 (64 Bit Cluster). These servers both reside on different domains but have connectivity between them using SQL Authentication... 21 Mar 2010 23:13

Many to many table design question
Originally I had 2 tables in my DB, [Property] and [Employee]. Each employee can have 1 "Home Property" so the employee table has a HomePropertyID FK field to Property. Later I needed to model the situation where despite having only 1 "Home Property" the employee did work at or cover for multiple properties. ... 18 Mar 2010 21:12

MSSQL 2005, TSQL, Keywords and variables, Case sensitive or not?
Hello, Does anybody know, MSSQL 2005 T SQL language, are variables or keywords case sensitive or not? Regards ... 13 Mar 2010 08:36

Stored Procedure - Writeline Where
I am trying to create a stored procedure to write out to a text file. I would like it to write a line for each instance of a select statement. Any help? Write information Where field1 = String ... 8 Mar 2010 18:39