|
|
|
January 2003 March 2003 April 2003 May 2003 June 2003 July 2003 August 2003 September 2003 October 2003 November 2003 December 2003 January 2004 February 2004 March 2004 April 2004 May 2004 June 2004 July 2004 August 2004 September 2004 October 2004 November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 November 2007 April 2008 |
Filter by Day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 xpsql70.dll Posted by welyngj at 9/20/2003 10:37:04 PM I run those codes like this:
USE master
EXEC sp_dropextendedproc 'xp_cmdshell'
go
use master
exec sp_addextendedproc 'xp_cmdshell','xpsql70.dll'
exec xp_cmdshell 'dir d:'
system reports me the error:
cannot load dll xpsql70.dll
reason:126(cannot find special module.)
how to slove this ...more >>
Single User Mode Query Posted by Benjamin Kelly at 9/20/2003 10:06:26 PM I need a query to put the database into a single user
mode. I tried this there was an error near SET.
Alter Database [Goldmine_Sales_and_marketing] SET
Single_User with rollback immediate
...more >>
TOP Posted by Luís Serpa at 9/20/2003 6:02:01 PM Hi
i whant to select all my record's from a table but not included the frist 5
i whant to do the oposite of the TOP 5
thank's
Luis Serpa
...more >>
Auto pulling data from SQL server A to SQL server B Posted by Jean Wang at 9/20/2003 4:14:53 PM Hi,
I have 2 Sql servers (2K) in different buildings. Each of them has different
databases/data elements. When the first server's database table, called
PersonalInfo is updated or a new record is inserted, I need to insert the
same updated/added data to the second server's database table, cal...more >>
Retrieving records based on dates Posted by Kerri at 9/20/2003 2:47:41 PM Hi,
I have a date 3/1/2004 (mm/dd/yyyy).
I have a DB table that contains dates before and after
this date.
I want to get the date that falls just before thsi date
from my table.
Currently I do a ...
SELECT TOP 1 MyDate
FROM MyTable
WHERE MyDate < 3/1/2004
This is incorrect. Ho...more >>
Renaming SQL Server Posted by Sender at 9/20/2003 1:30:12 PM The name of the computer where SQL SERVER is installed is "COMPUTER". The
SQL Server 2000 name is 'VPG\VPG'. I wanted to change the servername to
'SERVER'. So I run the following 2 sql statements in QA:
sp_dropserver 'VPG\VPG'
sp_addserver 'SERVER'
The command ran successfully. Then I re-st...more >>
Equivalent of SUBSTRING in DTS VBScript. Posted by Sender at 9/20/2003 12:32:14 PM What's the equivalent of T-SQL SUBSTRING string function in DTS VBScript.
Actually, I am copying the data from an Excel Sheet to a table in SQL Server
using DTS. In the Excel Sheet there is one field Address. In the table there
are two fields Addr1 and Addr2. I want that if the
len(DTSSource("Ad...more >>
Sql server and Access link tables Posted by eisoffind at 9/20/2003 12:20:49 PM
Hi
We are having application which is developed in Access and backend also
Access. We have just created the link in access and running the
application.
We are migrating in sql server. In the current application we have used
dao. We changed it to Ado. But as compared to original application ne...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
copying stored procedures to another database... Posted by Sender at 9/20/2003 11:01:12 AM (1) What's the quickest way to copy dozens of stored procedures from one
database to another using Enterprise Manager?
(2)When I right-click on any stored procedure there is "copy" option. What
does this option do?
Thanks in advance!
...more >>
change system message... Posted by M-R at 9/20/2003 8:24:44 AM
Hi
I've created an encrypted view in SQL Server 2000.
now I want to know is there a way to change system message
'The object comments have been encrypted.',
when we want to view the text of it?
any help would be thanked.
--
Using M2, Opera's revolutionary e-mail client: http://www.oper...more >>
xp_cmdshell Posted by Rob at 9/20/2003 8:19:13 AM Hello:
When I run the following command to output the dir listing
of all my backup files...
EXEC xp_cmdshell 'dir \\Server1\F$\Microsoft SQL
Server\MSSQL\BACKUP\DB\BRW1'\BRW1_db_*.bak /B /A:-D /O:-
D /T:W'
....SQL Server reports, "The system cannot find the path
specified."
It see...more >>
HELP SQLAgent won't start - login failed for SA Posted by Fred at 9/20/2003 6:49:33 AM The sys admin's rebooted the server and now the sql server
agent won't start. The error message is
[298] SQLServer Error: 18456, Login failed for user 'sa'.
[SQLSTATE 28000]
Any idea's?? I'm working from home and stuck
Thanks
Fred...more >>
Check constraints Lookups - HOW? Posted by Harag at 9/20/2003 6:21:50 AM Hi all
Win 2k pro
SQL 2k Dev ed
ASP - vbscript
I got 2 tables, 1 a Jobs look-up table and a employers tables
create table lookup_jobs
(JobID int primary key,
JobTitle varchar(50)
)
create table Employers
( EmpID int identity (1,1) primary key,
EmpFirstName varchar(50),
EmpLastN...more >>
Error message from another SP? Posted by Paul Hatcher at 9/20/2003 4:13:25 AM Is it possible to access the error message raised by
another stored procedure?
For example, I have two stored procedures A, B with A
calling B.
B has a number of possible error conditions giving
different error messages, but I want to trap the error
message and modify it before giving ...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |