i use C#, .Net to connect to SQL Server2000 & Sybase12.0,
1. connect to SQL Server and do something;
2. connect to Sybase and do something;
3. connect to SQL Server and do something;
the ...
I am trying to reseed an Identity column in Sql server CE on a pocket pc device but the
dbcc checkident (table, reseed, 14) doesn't seem to work. The reason I am doing this is to work around...
Hi,
I'm using a VIEW to select data from a linked Oracle server. To do that I'm using an OPENQUERY clause. My problem is that OPENQUERY doesn't seem to allow variables and I would like to h...
I am newbie to full text search and have a question about input parameters of a sstored procedure and full text search
I'll explain by example:
@keyword --this input comes from web page ...
I am trying to copy over one database to another across hosting companies.
I only have db_owner permissions on one table, but not the other.
Is the db_owner permission required (on both ...
I want to create a table which stores usernames and passwords. The problem is that a lot of persons has access to this database/table and in this way the information is not safe.
I'm not so...
Ho do I calculate a leap year in SQL?
Hi, I noticed a new process on my clustered sql server. I am wondering if it could be a virus.
( i'm running sql 2000 on win2k, active - passive clustering ).
---Process INFO---:
The pr...
How can I make a view dynamic by using another SQL Query?
I have a view that has a where clause with IN ('dept1', 'dept2', 'dept3') I need to make the view read another table in the databa...
How can i create a instert statment for all data from table1.
I like to create this for Initialize table backup.
Example :
Insert InTo table1(field1, field2,field3)values (1,'001','21')...
Hi,
I need to bring some 'TIF'-Files to MSSQL-Server. - Have read about the 'image'-datatype and about funtions like 'readtext' or textptr. - But I still need some help.
Regards,
Lude
dear sirs;
someone accidentally format my Sql Data Partition on my hard. I can recover the MDF and LDF database file again . But when i want to attach Database in SQL-Server I gor An Error me...
Hi,
I would like to put the result of a query into a variable. Normally this is not a problem and it works like this
@result = 'select count(*) from table1 where col1 = 'abc'
But how d...
When I create a trace with the profiler, I can choose a database and table to put the trace in. Now I want to do the same in T-SQL and use the sp_trace_create command. However, I can only writ...
Hi
I'm trying to use OSQL/BCP to export the result of a query to a text file. It's working nicely, but outputs each record as several lines. I'd like to have each record as one line, so t...
Here's my stored procedure:
CREATE PROCEDURE dbo.UpdatePerVehRegByUserIDandCompany
(
@strUserId VARCHAR(10),
@strMyCompany VARCHAR(50)
)
AS
UPDATE tblPersonalVehicleRegistration
SE...
I have recently assumed a team responsible to support an aplication which uses MS SQL 2000 as its DBMS.
Everyday, from 5:30 in the morning until 11:30 am the server utilization goes up appa...
I have a table [History] with a column [Data], data type image.
Is it possible to query the the size of data similar to using len when handling strings?
Something like (but valid):
sele...
I'm trying to quickly create a SQL 2K database approx. 30 Gb big. I've created a table containing a single column that's defined as char(8000). I believe that every time I insert a row into th...
Hello SQL experts. I think it is possible that I won't be able to provide enough info for you to help me, but I'll try.
We are using a work management software package with SQL 2000 at the ...
I am running Windows 2000 SP4 and SQL Server 2000 SP3. I create a simple replication where I select all the tables in a database to be pushed to a subscriber. The snapshot is created fine bu...
I'm hoping that someone can help me. We had issues on our production database. We found two indexed views, "_hypmv_0" and "_hypmv_1" on a table that we were trying to insert some logging inf...
I've stopped SqlServerAgent from one computer different from one where SQL Server run, and when I've tried to restart the service I've got an error:
[LOG] Exception 5 caught at line 173 of fi...
I have two tables, tableA and tableB. I want this tables to SYNC each other with Triggers.
On TableA I have the following Trigger:
CREATE TRIGGER TABLEA_UPDATE ON tablea FOR UPDATE
AS...
We have a active/passive clustered sql server.
Does anyone know a way to figure out if a cluster has failed over to the secondary node?
Anything will help.
Thanks!
