I have made a project using VB and it's DataEnvironment
when I setup my package in some computer, the .exe file returns an error:
"The given type name was unrecognized"
while running ...
Thank you for your input at
http://www.experts-exchange.com/jsp/qManageQuestion.jsp?qid=20268887
Thank you for your input at
http://www.experts-exchange.com/jsp/qManageQuestion.jsp?qid=20268887
When I import from Access creating a new sql table Access creates a column typed 'ntext' for fields that had been Memo in Access. My ASP pages refuse (no errors...just no data) to output ntext...
Hi experts,
I understand that 'sp_attach_single_file_db' can automatically create a new log file, if it can't find one. But, what I have observed is it always creating the log file in the s...
When i am trying to run query i get the following error:
Server: Msg 4408, Level 16, State 1, Line 1
The query and the views or functions in it exceed the limit of 256 tables.
the query...
hello, what's is uniqueidentifier datatype in MSSQL? I've just created a field with this type and trying to fill it, but i've got error message: "the value you entered is not consistent with t...
I am attempting to set up a simple snapshot replication between two SQL 2000 servers. I have set a machine up to do a pull replication from another machine. The setup process seemed to work fi...
Hi, I want to write a query to list all tables in a particular database having 2 columns
Name | No. of Rows.
Thanks.
Found this in the SQL log. Does anyone know what it means? Why would it place an entry in the log when it uses a particular dll? Is is something that I should be worried about?
Thanks fo...
HI,
How can I copy a whole table and some certain records from one DB to another.
The two DB are identical, but run under a diffrent Ip address.
I execute the SQL commands in MFC applicatio...
Does the replace function not work in SQL 6.5?
Here is what I am trying?
/* Delete existing data */
DELETE FROM DEV_INTERFACES..AFS
INSERT INTO DEV_INTERFACES..AFS
(name,
...
Hello,
I would need help with the GROUP BY and HAVING clauses.
Suppose I have the following table: mytable
field1 field2
------ ------
a 1
a 2
a 2
b ...
I have a job that executes an sp everyday at 00:10. Recently I got the following error when the job should have run:
The job failed. Unable to determine if the owner (SERVER\Administrator)...
Hey guys,
We have a server with a large number of user databases. (currently 300 odd)
We have a bit of a job managing backup history in MSDB for this server.
I can't believe Microsoft...
I have a question regarding xp_sendmail in sql server 2000.
SQL Mail is using an Outlook profile called 'SQLMail',
which I have configured with a mailbox called 'SQLMail'.
The sa_sql-acco...
Hi,
I need to get access to the statistics of an index(AccountPrimary) on a table(Accounts).
What i require is the date and time that the index was last changed.
I know it is possible to d...
Hi,
I need to load a file of which the row terminator is only a linefeed (0A). How can I load this file? BULK INSERT only has \n (0D0A) and \r (0D) as row terminators. If you use \n, BULK I...
I have copy of rdb on SQL Server 2000.
Db has 22 tables and All of the tables
have field ID(PK) & relationships between .
I need to assign NEWID to all records in this format
00-001-0...
i use sql server 7.
1) how to declare varchar array of 2 dimension and how to use it?
2) How to lock a table [i want to lock when a critical procedure is being executed. i want the table to ...
How do you mage filegroups in SQL Server? Can you associate tables to filegroups? I am used to Oracle and wondering if filegroups are szupposed to fill the same roll as tablespaces?
I am having trouble with the syntax to set the 'Recovery_Option' on a database. It is
currently set at 'simple' and I need to
change it to 'full'.
I am looking at the help file, but I am...
I am no expert so this is probably embarrassingly easy for you experts out there but why is this simple 1st statement so much quicker than the simple 2nd (with subquery)?
1st:
DECLARE @t...
I need to insert a couple of pictures (.bmp) into an Image field in a SQL Server 2000 table, this is just a test table to demonstrate to someone what can be done.
How can I do this?
Hello,
I'd like know how can we create an output file to receive the result of one STORE PROCEDURE like that
CREATE PROCEDURE myproc
@test int OUTPUT
AS
SELECT * FROM Journal
RETUR...
