Continuing his series on SQL Server and InfoPath 2003, the new reporting tool that has been added to Office. This time Dinesh looks at a practical application using expense entry along with some more features of this new tool.
2004-09-14
7,096 reads
Win XP Pro limits users to one web site, but developers often need to be able to switch between sites when coding locally. This free tool let's you easily do just that. Why an article on an IIS tool on a SQL site? We think it might be useful to you or someone on your team, and lots of SQL developers use IIS as well.
2004-09-03
5,759 reads
Sometimes you need an audit trigger on a table. I have created a generic trigger that will work for (almost)every table. if the audit table is not there yet, It will copy the table structure (but strip identity attributes) and put all the data in an AUDIT_ table.I believe this will work for almost every […]
2004-09-02
1,619 reads
Continuing with Dinesh Asanka's series on SQL Server and Infopath 2003, he shows us this time how to build a report that joins two tables and includes some conditional formatting. Infopath 2003 is part of Office 2003 and is a great quick and dirty tool for getting to your SQL Server data.
2004-08-31
7,537 reads
A short tutorial on building database back-ended applications with SQL Server and CE. If you're looking to build mobile apps, this is a good place to start.
2004-08-31
541 reads
Ussualy this kind of scripts queries sysobjects and syscomments like this:select distinct object_name(O.id)from syscomments as Cjoin sysobjects as O on O.id = C.id and o.type = 'P' -- search string only in stored procedureswhere C.text like '%insert into MyTable%'When the text of stored procedures, triggers, functions is over 4000 characters, it is saved in syscomments […]
2004-08-26
254 reads
This script notifies the DBA or Developers with the list of failed jobs. This script useful if you want to use either Mater-Target server option or even single server to monitor the Target servers jobs. You must have SQL MAIL configured on the SQL Server.
2006-02-20 (first published: 2004-08-25)
2,122 reads
Hurricane Charlie had a pretty substantial impact on residents and businesses in Central Florida. Andy lives in the Orlando area and wrote up some notes on the various challenges he ran into it. Out of it you might find a couple things worth thinking about adding into your DR plan.
2004-08-24
6,298 reads
Here is a simple view that is useful to pull basic data dictionary information out of your DB user tables. The description field is an extended property that I like to use for built in documentation of fields. This only works with 2000, 7 had a slightly different layout for the system tables.
2004-10-27 (first published: 2004-08-20)
346 reads
This SP takes a string to be searched as input parameter, loops through all tables, views, Sp-s in the database andreturns the name of the object it was found and number of occurences
2004-12-10 (first published: 2004-08-18)
668 reads
By Arun Sirpal
Until now, a CRITICAL finding did the right internal routing, but the last mile...
By Steve Jones
This is actually inspired by an article SQL Server Central, which taught me something...
By alevyinroc
T-SQL Tuesday is a monthly blog party hosted by a different community member each...
Telp Cs:(0821)8200174 Jl. Jenderal Ahmad Yani No.1, Benua Melayu Darat, Kec. Pontianak Sel., Kota...
Telp Cs: (0821)8200174 Jl. Jend. Sudirman No.17, RT.008/RW.04, Pangkal Lalang, Kec. Tj. Pandan, Kabupaten...
Comments posted to this topic are about the item How Clustering can be Used...
How can I change the location in which the SQL Server error log is written in SQL Server 2025?
See possible answers