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
Search tool for SQL
Posted by BA at 2/3/2006 6:32:58 PM
There are a few people at my company that are not familiar with SQL, but it
would be benificial if they were able to search for text within a database
and report on tables. Is there a freeware tool out there that will connect
to a sql db and allow you to search for text?
DTSRUN.exe Fails to Initialize
Posted by lutzdw at 2/3/2006 5:21:07 PM
I have been seeing these intermittently in our event logs...
Event Type: Information
Event Source: Application Popup
Event Category: None
Event ID: 26
Time: 6:00:30 PM
Posted by mecn at 2/3/2006 4:48:57 PM
Can I create a job like this in sql 2k?
Does the second step will run?
Isolation levels and SELECT's (even when using SERIALIZABLE!)
Posted by JBilger at 2/3/2006 3:54:36 PM
I thought that it would be interesting to point out some very subtle
issues that can occur when using SELECT's inside a transaction that
also includes INSERTS/UPDATES or DELETES.). The issues really arise
when concurrency occurs (ie many users trying to execute this
transaction at the same time ...more >>
question about using various DBs
Posted by sklett at 2/3/2006 3:31:00 PM
I'm designing our suite of new applications (sigh) and we're going to be
storing all the data in SqlServer 2005. I'm hardly a "DBA", I have used
access in the past, but never designed a full system. The issue I'm hung up
on is how to determine what tables should be in their own separa...more >>
identifing what DB I've got
Posted by gerryR at 2/3/2006 3:27:08 PM
apologies for the question but we run ePO (anti virus management software)
and are moving everything to a new server so I need to back up the ePO
database and import it to the new server. Problem I'm having is identifing
if I have a Microsoft SQL database or a MSDE database as there...more >>
Urgent - Slow join across SQL Linked Server to InterSystems Cache
Posted by steven NO[at]SPAM ironcube.com at 2/3/2006 1:12:52 PM
I am a newbie to this discussion forum. If I'm bending/breaking any
of the rules, please let me know.
I need some major help with a linked server I setup. I have a cache
database that we can only access through ODBC (no mumps). I have a SQL
database, db01, which is storing data...more >>
Table Hierarchy is SQL Server 2000
Posted by Ganesh Muthuvelu at 2/3/2006 11:51:30 AM
If in a database, "table3" depends on "table2" and "table2" depends on
"table1" - how would I write a query (on the system tables) which will take
"table3" as a parameter and return me this result as below in a hierarchy?
Name Parent Table Name
table2 ta...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Rowsize exceeded error, but rows already exist that exceed the size..?
Posted by Nate at 2/3/2006 11:06:43 AM
I am trying to add a new table and foreign key relationship to an
existing SQL Server 7.0 database. When I try to save in EM, I get a
rowsize exceeded error...
[Unable to create relationship 'FK_existingTable1_newTable1'.
ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]AL...more >>
SQL 2000 Discontinued?
Posted by Dragon at 2/3/2006 10:59:49 AM
I heard that SQL 2000 Server has been discontinued. Is this true? If yes,
any official advisories on the web?
Enterprise Manager Tape Backup issue
Posted by sigm at 2/3/2006 10:59:18 AM
I have multiple failed backups jobs through the enterprise manager. I have an
event id 9 "\device\scis\aic78u21 did not respond within the timeout period"
and event id 15 "\device\tape0 is not ready for access yet." The aic78u21 is
the scsi controller and only appeared once. Since then, I have...more >>
unexpected log growth during bulk inserts
Posted by me at 2/3/2006 10:30:47 AM
We're performing bulk inserts into a database with the bulk_logged recover
model and seeing the log file grow by 3x the size of the data file as a
result of the bulk insert. This is not expected at all.
A sample command:
BULK INSERT Pulses_best
WITH (T...more >>
Posted by Diane at 2/3/2006 9:09:59 AM
I am not sure if this is a stupid question, but here goes ... What does
"improper use of cursors" mean? I mean, I know what a cursor is ... i just
don't understand what its relevance is to SQL ... I would be grateful for any
Posted by Mica Cooper at 2/3/2006 8:46:08 AM
I set up several backups in individual databases to back up on a weekly
basis. Later, I set up a maintenance plan to back up all the databases
nightly. I am now trying to find where I can delete the weekly backup
schedules but cant find them. How do I go about this? The docs on backups ...more >>
Restrictions x64 SQL?
Posted by Michael Roedeske at 2/3/2006 8:16:04 AM
some months ago, I saw a website stating the restrictions of the x64 SQL
implementations. Now I need them for a decision, but cant find them anymore.
Can someone help me out?
TEMPDB is growing
Posted by Ali Grey at 2/3/2006 7:56:49 AM
We have a fairly large SQL Server installation and we have noticed recenlty
that the TEBMPDB is growing.
Can someone tell me why this would be the case? What makes TEMPDB grow?
We are using SQL Server 2000.
Posted by The One at 2/3/2006 7:54:46 AM
are there any good articles on tunning SQLServer 2000. I am new to
SQLServer DBA work, but I have a lot of DBA experience with Oracle and
John The One...more >>
Problem with Collation on SQL 2000
Posted by robin9876 NO[at]SPAM hotmail.com at 2/3/2006 7:34:44 AM
On a live SQL Server 2000 in the last week I have noticed a problem
with collation with the Model and tempdb both changing from
'Latin1_General_CI_AS' to 'SQL_Latin1_General_CP1_CI_AS'.
I am not aware of anybody changing these settings. Do the any of the
log files record when these values have c...more >>
Log restore : There are no back up files in the set
Posted by bluefish at 2/3/2006 7:14:10 AM
I am fairly new to the log shipping, and trouble shooting our log shipping
operation. We are using SQL Lite to back up, and some log backups are
visible, but fail to apply with the following message.
There are no back up files in the set, check for cancelled backup operations.
Has an...more >>
Schema permissions doubt (SQL Server 2005)
Posted by Alex at 2/3/2006 6:48:48 AM
Maybe I have a very simple question ...
I have a requirement that is very apropriate to use schemas.
I understand that one of the advantages is to simplify the permission
management and that I could assign a kind of 'dbo' permission inside a
I did the following steps:
Call Stored Procedure AS400 From SQL Server
Posted by Portekoi at 2/3/2006 6:02:57 AM
I have SQL Server 7 with a link server.
When i try to execute a SP from SQL Server, i have this error :
[ OLE/DB provider returned message: [ IBM][Pilote ODBC iSeries
Access][DB2 UDB]SQL0107 - "pack14rexe" is too long. 10 characters
maximum are accepted. ]
I try this : exec recet...more >>
slow triggers with lots of rows?
Posted by sethpurcell NO[at]SPAM comcast.net at 2/3/2006 5:52:16 AM
Hi there -
I'm experiencing slow inserts on tables with AFTER INSERT triggers on
them. I think it's because I'm joining to the [inserted] table to
determine which rows in the trigger table were just inserted, and there
are sometimes hundreds of thousands or even millions of rows inserted
by a...more >>
how to specify sender when using xp_sendmail
Posted by foru123 at 2/3/2006 4:24:56 AM
When execute xp_sendmail as below:
EXEC xp_sendmail @recipients = 'firstname.lastname@example.org'
The recipient will see the mail sent from sql server. Is there a way to
specify my email address when execute xp_sendmail so that the recipient
will see the email address sent from me not from sql server?
Posted by Rob at 2/3/2006 3:20:46 AM
Hi... two questions:
1. When adding an additional data and/or log file, does SQL Server accept
these changes dynamically or would one have to restart SQL services for the
changes to take effect?
2. When using the BULK INSERT command with the BATCHSIZE option, if the task
fails half-way t...more >>
Maintenance Plan Failed SQL2005
Posted by Otte at 2/3/2006 2:01:51 AM
I am trying to create a simple Maintenance Plan using the Wizard to
backup my databases. When I click finish everything works fine apart
from the last step, "Saving Maintenance Plan". The report I get is
Maintenance Plan Wizard Progress
- Creating maintenance plan "MaintenancePlan" (...more >>
Posted by ch.funke NO[at]SPAM googlemail.com at 2/3/2006 12:24:05 AM
I have a table with text-items in different languages. There are
columns TextID, TextItem and LanguageID (and one more ID with primary
sample: TextID says "I am at home" in 10 languages, each with it's own
LanguageID. So this textids has 10 entries.
Some texts are only avail...more >>
Multiple Active Result Sets (MARS)
Posted by Griff at 2/3/2006 12:00:00 AM
Two questions relating to this:
1 - Do I require SQL Server 2005 or can this work with SQL Server 2000?
2 - My ASP.NET book says that I require MDAC 9.0. My registry setting says
that I'm using 2.8 but I can't find where I can download an update from.
Thanks if you can help with either of ...more >>
Enterprise manager error in SQL 2000
Posted by Rowland Costin at 2/3/2006 12:00:00 AM
Hope someone can help me as I am having major problems. I have seen this
before but none of the usual fixes seem to work.
Had a serious crash on my Win XP Pro SP2 PC causing a permanent reboot
cycle, so I reinstalled Windows XP Pro. Note, after this I have had major
problems wi...more >>
Is it any functions similar to "START WITH" and "CONNECT BY" in MS SQL?
Posted by delolwai at 2/3/2006 12:00:00 AM
I am looking for some functions which are used as "Start with" and "Connect
By" in Oracle. Please help! Thx a lot.
change instance name?
Posted by wcccj at 2/3/2006 12:00:00 AM
Is it easy to rename an instance, or change an instance to default instance?
Basically I have an SQL 2000 Standard and MSDE installed on same machine,
and I would like to swap around their instances.
requete SQL select d'une SP
Posted by Ch. at 2/3/2006 12:00:00 AM
Comment faire ce genre de requete ?
select top(10) T.*
from ( exec SEL_MODELES 767 ) T
WHERE T.ID > 50