|
sql server 7.0 backup script.
Can any one send me the script of SQL SERVER 7 "DATABASE BACKUP script"
AUTO BACKUP THE ALL DATABASE BACKUP
Thanks
NOOR
...
Thu, 7 Oct 2004 23:49:43 -0700
|
Error 1203 severity 20
When trying to update a database via Popkin's System Architect I get error
1203 severity 20. More details are below.
System: Dell 4400 series 2 processor Xeon 867MHz, 512MB, Windows 2003
Server, SQL Server 2000 SP3a.
Application: Approximately 40 MB database on SQL Server being used by
Popkin's System ...
Thu, 7 Oct 2004 13:55:38 -0700
|
Minimum Hardware Requirements For SQL Client
What would be the minumum hardware (and software) requirements to have
SQL client on 10 of our contractors' computer with a maximum database
size of 5GB?
Thank you very much
mike ...
7 Oct 2004 09:14:08 -0700
|
how SQL SEVER work in VPN??
dear experts!!
i would like to know some knowledge on Virtual Private Network relating with
MS SQL SERVER 2k.
the thing goes like this: there's a company that have 5 branchs (including
HQ) that are differently geographical distirubted,
now they like to set up the VPN as thier netowrk backbond by not lett ...
Thu, 7 Oct 2004 08:21:01 -0700
|
Reporting Services Subscription
Dear all,
I have currently was using the SQL Server 2005 Evaluation
Copy for testing or R & D purpose for Reporting Services
Tools. Now I am in the stage of testing out the
Subscription of Report through our emailing system. I
have setup the email server or SMTP Server and with the
FROM email address v ...
Wed, 6 Oct 2004 21:57:22 -0700
|
Mass loading SQL SERVER stored procedure
Hi All,
We are during the coding of SPs in one project. Each SP is one .sql file
and these files are becoming more and more. We use Query Analyzer to
open .sql file and execute the script to create SPs one by one. It is
obviously time cosuming and bring some mistake. Do anybody have a good
way of mass loadin ...
Wed, 06 Oct 2004 11:34:31 -0700
|
T-SQL Backup RetainDays
I created a Job with T-SQL to backup a database and retain it for seven
days. Each night's backup has the date and time of the backup as part of its
name. Unfortunately, after seven days the earlier backups are not being
deleted.
At first I thought it was because the backups have different name ...
Mon, 4 Oct 2004 17:21:02 -0700
|
Data encryption for results of query using ADO
Hi,
I'm using ADO to connect to a SQL Server.
I want to execute a query which reads sensistive information and ensure that
the results of the query cannot be sniffed on the network
Can I enable encryption for a specific connection to the SQL Server without
forcing either the client machine or sql server to e ...
Mon, 4 Oct 2004 19:11:49 +0530
|
Insert and Update Remote server through Begin Transaction
I have created the link server and inser the record remotely through begin
transaction but it gave me an error.
After that I have used this
set begin transaction
SELECT a.* FROM
OPENROWSET('SQLOLEDB','Noor';'sa';'xorbix', 'insert into
sugarv4facility1.dbo.Patient SELECT * FROM sugarv4facility1.dbo.Pati ...
Mon, 4 Oct 2004 04:56:23 -0700
|
SQL server access problem
Hi
i have a windows xp pro, i using odbc to connect to sql 2000 server. i have
two connection that work fine. Now when i try to connect i receive a popup
message of error.
If i try to configure or recreate my odbc i receive the followin errors:
impossible make connection
sqlstate: '01000'
sqlstate: '08001'
...
Mon, 4 Oct 2004 09:46:51 +0200
|
Using DTC via Firewall
Hi,
My application may execute some SQL statements using DTC. After I've
installed Windows XP Service 2, those SQL statement doesn't work (it's
orginially used Service Pack 1). I've found that there is a firewall is
deployed with SP2 and I've disabled it at all. What's happened?
P.S. Client side: MSDE 2000 ...
Mon, 4 Oct 2004 12:47:26 +0800
|
MDX measure calculations error in Excel in XP environment
Hi,
With a calc measure from a AS 2000 or local cube, into
Excel 2000 or 2003 in an XP (Home or Professional)
environment such as:
"(Sum([Region Name].currentmember.level.allmembers,
[Measures].[Population]))
/
Sum({[Virtual Age Group 2].currentmember.parent},(Sum
({Ancestor([Region Name].currentmembe ...
Sun, 3 Oct 2004 21:14:14 -0700
|
CHARINDEX in user-defined function
Hi,
I'm trying to use the CHARINDEX built-in function in my user-defined
function, but it doesn't seem to work.
Right now I got down to only write a test-function that doesn't do anything
else but call charindex:
CREATE FUNCTION X(@p_str1 VARCHAR, @p_str2 VARCHAR)
RETURNS INT AS
BEGIN
RETURN CHARINDEX(@p ...
Sat, 2 Oct 2004 21:39:44 +0200
|
Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection
Hi,
I have a windows setup program (framework 1.1), this setup
program calls one util.exe with parameters. util.exe opens the connection
(SQL Server 2000, windows authentication only) and does some db updations.
when i run thru setup exe fails throwing
"Login failed for user '(null)'. Reason: Not associated w ...
Sat, 2 Oct 2004 12:35:39 +0530
|
how to view log file of sql server 2000?
...
Sat, 2 Oct 2004 11:42:28 +0800
|