 |
Backup ALL your SQL Server 2005 databases using ONE script
Paul Hayman (8510 views)
Backup ALL your SQL Server 2005 databases using ONE script
I wanted to backup all my databases... I had loads, creating a step for each db was getting tedious, so I wrote this script.
Enjoy
#s#DECLARE @DBName varchar(255)
#s#
#s#DECLARE @DATABASES_Fetch int
#s#
#s#DECLARE DATABASES_
|
 |
XMLHTTPRequest in Stored Procedure
Dave Howard (4275 views)
XMLHTTPRequest in Stored Procedure
I recently had a requirement to call a webservice from a stored procedure. I looked into doing this by writing a CLR assembly in SQL 2005.
There were a few articles online describing this but working in a large organisation I knew that getting the thing wor
|
 |
T-SQL script automatically adds auditing to a table
Dave Howard (13602 views)
T-SQL script automatically adds auditing to a table
#$#<a href="http://www.dotnetkicks.com/kick/?url=http://www.geekzilla.co.uk/ViewECBC0CC3-1C7E-4E7E-B243-F2F259A5C920.htm"><img src="http://www.dotnetkicks.com/Services/Images/KickItImageGenerator.ashx?url=http://www.geekzilla.co.uk/ViewECBC0CC3-
|
 |
Select Column Information using SQL Server
Dave Howard (27116 views)
Select Column Information using SQL Server
#$#<a href="http://www.dotnetkicks.com/kick/?url=http://www.geekzilla.co.uk/ViewF3E9658C-7B7A-472C-BE4A-5C25CD26C0E8.htm"><img src="http://www.dotnetkicks.com/Services/Images/KickItImageGenerator.ashx?url=http://www.geekzilla.co.uk/ViewF3E9658C-7B7A-472C
|
 |
Bug in VS2005? Using Typed DataSets with SQL 2005 and stored procedures
Dave Howard (6664 views)
Bug in VS2005? Using Typed DataSets with SQL 2005 and stored procedures
#$#<a href="http://www.dotnetkicks.com/kick/?url=http://www.geekzilla.co.uk/View72C81AA0-44A5-4E2C-8903-B1EA7D7643EA.htm"><img src="http://www.dotnetkicks.com/Services/Images/KickItImageGenerator.ashx?url=http://www.geekzilla
|
 |
Enabling Agent XPs on a new SQL Server 2005 install
Dave Howard (8434 views)
Enabling Agent XPs on a new SQL Server 2005 install
I had to do this prior to creating a maintainence plan for a database on my development box.
When i first tried to create the plan I was given a message that Agent XPs are not enabled and that I should run sp_reconfigure.
Run this state
|
 |
Exporting large amounts of Data from SQL
Danny Mehmed (1589 views)
Exporting Large amounts of Data from SQL
If you have ever had an issue transfering large amount of data from SQL you can use the command line tool to solve this problem.
From the command line
#s#bcp [<database_name.>[<owner>].]<table_name> out <csv-file> [/U<username>] [/P<password>] [/
|
 |
Full Text Search in SQL 2005
Ric Hayman (14158 views)
Full Text Search in SQL 2005
Full Text Search was installed when SQL Server was installed and a service was running, so I expected it to just be sitting there waiting. This is unlike SQL 2000, where I lost count of how many times I had to install it on different servers.
Was I wrong in exp
|
 |
Extending Strongly Typed Datasets
Dave Howard (3164 views)
Extending Strongly Typed Datasets
Strongly Typed Datasets are a rather nice addition to VS2005 (they don't lend themselves well to acronyms however)
You still need to create a database and tables and realationships but using STDs saves a writing huge amount of code.
If this code were gene
|
 |
Change Database Owner Following Restore
Greg Duffield (1073 views)
Change Database Owner Following Restore
I upgraded a SQL 2000 database to SQL 2005 by backing up and restoring.
However when this was done, the database does not have a valid owner and you will not be able to add diagrams etc.
To resolve this you will need to run the following SQL
#s#E
|
 |
Intellisense For SQL Server Query Analyser
Greg Duffield (852 views)
Intellisense For SQL Server Query Analyser
Query Analyser has always been missing something and that something was [intellisense]. Just think about the time this would save you not having to have to look up the column names all the time or how to use a T-SQL function you have not used for some
|
 |
Change the Owner for Stored Procedures
Greg Duffield (8443 views)
Change the Owner for Stored Procedures
This one comes from Tim Page, if you ever need to change the owner of several Store Procedures at the same time then this is the T-SQL for you. And this even supports SQL Sever 2005.
#s#DECLARE
#s# @OldOwner sysname,
#s# @NewOwner sysname
#s#
#s#
|
 |
Strongly Typed DataSets and GridViews
Dave Howard (5679 views)
Strongly Typed DataSets and GridViews
#$#<a href="http://www.dotnetkicks.com/kick/?url=http://www.geekzilla.co.uk/ViewF9581DAE-CCF8-49FF-844C-7498603E0005.htm"><img src="http://www.dotnetkicks.com/Services/Images/KickItImageGenerator.ashx?url=http://www.geekzilla.co.uk/ViewF9581DAE-CCF8-49FF-84
|
 |
GRANT Permissions on all of your Stored Procedures using a query
Paul Marshall (11555 views)
GRANT Permissions on all of your Stored Procedures using a query
Permissions are an essential security feature, and you'll often create Roles and Users when you copy your Database live. Rather than using the permissions dialog boxes in Enterprise Manager you can write some T-SQL to perform the
|
 |
Problem With SQL Server 2005 on Vista Beta2
Mark Page (2857 views)
Problem With SQL Server 2005 on Vista Beta2
So you've been through the throws of building a Vista Beta 2 installation and boy it looks good. Maybe a couple of missing drivers to hunt down but otherwise all that Vista goodness.
So now you want to install some developer tools and start to play
|
 |
Fixing broken users after Database Restore
Paul Hayman (2507 views)
Fixing broken users after Database Restore
Ever restored a Database which was created on a different server then not been able to use the same logon you had previously set up?
This command fixes the problem with the account.
#s#-- Replace username with the account to fix
#s#sp_change_users
|