|
|
 |
Error : When I try to backup to a Network share
|
| Total Hit (2876) |
I get the following error message: «b»"Can't open dump device ... device error or
device off line. Please consult the SQL Server error log for more details."«/b»
«b»«u»Resolution:«/u»«/b»
To perform SQL Backup on network share SQL Executive service needs to run under an account that has permis
....Read More |
Rating
 |
|
|
|
generate INSERT statements from existing data.
|
| Total Hit (3196) |
This procedure generates INSERT statements using existing data from the given tables and views. Later, you can use these INSERT statements to generate the data. It's very useful when you have to ship or package a database application. This procedure also comes in handy when you have to send sample d
....Read More |
Rating
 |
|
|
|
Example for encrypting data using XOR
|
| Total Hit (1832) |
Functions to encrypt data in columns are not available in SQL Server (except undocumented ones that are risky to use & not supported). Here is one that shows how to do this using XOR.
«code LangId=6»DECLARE @pwd varchar(30) , @encryptkey int , @encryptedpwd varchar(30) , @charpos smallint;
SELE
....Read More |
| Rating
|
|
|
|
|
|
|
|
|
|
|
|
Linked Severs on MS SQL Part 4, Oracle
|
| Total Hit (2312) |
In previous articles, we created Linked Servers to Excel, Access and MS SQL. Several stored procedures were introduced for creating links, and the security profiles that accompany them. For this article, sp_AddLinkedServer and sp_AddLinkedSrvLogin should be familiar. Several different access methods
....Read More |
| Rating
|
|
|
|
|
|
Creating a SQL Server User Interface with InfoPath
|
| Total Hit (660) |
When Office 2003 is released about a month from now, some of the versions will contain two new applications OneNote and InfoPath. OneNote is a note taking application that may be interesting to those of you with tablet PCs. InfoPath is an XML based forms creation and entry application that looks ver
....Read More |
| Rating
|
|
|
|
Custom Assembly in Reporting Services
|
| Total Hit (1075) |
SQL Server 2000 Reporting Services is a server-based reporting solution that can deliver interactive Web–based reports. This article describes a problem that occurs when you access a custom assembly in your Reporting Services report that does not have sufficient permissions on the resources in your
....Read More |
| Rating
|
|
|
|
Setting Up Merge Replication: A Step-by-step Guide
|
| Total Hit (730) |
In this article, I want to tell you about some general Microsoft SQL Server replication's topics: replication topologies, replication types, and replication agents. I will also discuss Merge replication: how to check necessary conditions for this type of replication and how to backup and restore the
....Read More |
| Rating
|
|
|
|
Supporting DTS in SQL Server 2005
|
| Total Hit (945) |
Supporting DTS packages in SSIS ( SQL Server Integration Services ) is a daunting task for many. Let’s look at what you need to get the job done and get some good tutorials on the subject.
|
| Rating
|
|
|
|
DTS Servers and Schedulers for MS SQL
|
| Total Hit (2088) |
Learn the basics of creating a DTS server, including how to change the DTS package according to batch schedulers used and the steps required to create and schedule jobs in Autosys and Smartbatch.
|
| Rating
|
|
|
|
Execute a package from Visual Basic (VB)
|
| Total Hit (695) |
To execute a package from Visual Basic is a relatively simple task using the DTS object model. Before you start using the object model you must add a the appropriate reference to your project. From the Project menu select References and check the "Microsoft DTSPackage Object Library".
....Read More |
| Rating
|
|
|
|
|
|
Notification Services in SQL Server 2005
|
| Total Hit (1103) |
Notification Services is one of the features included in SQL Server 2005. As the name implies, Notification Services are services which send notifications to the interested entities based on what they would like be notified on. The addition of Notification Services to SQL Server 2005 has inherent ad
....Read More |
| Rating
|
|