Hi everyone, I have 3 tables: Telbook(Id:int,Name:char,address:char,comment:ntext,owneruserid:int), PK:id TelNumbers(telbookid:int,telno:char,telNotype:int,syscode:int),PK:syscode,F= =ADK:telNumbers.telbookid=3Dtelbook.id Teltypes(teltypes:char,fk:int),FK:telnumbers.telnotype=3Dteltypes.fk...more >>

well, I need to justify to my client, why to switch to sql2005 form 2000. I know a lot of 'why it's better', but my client don't really care most of those aspects. I need to argue, my client's business gains on that. Thnaks in advance. ...more >>

I wihsh to discuss whether to use fully qualified names: [database].[schema].object of objects to operate (create, query..) on is good or not? If someone change order of sql code blocks in my script - this may cause lose of it's context (like: use master / use <mydb>..). I wish to have m...more >>

Hello , My question is: does ms sql support two phase commit protocol? and Why if no. How if yes. Thank you ...more >>

I'm using Bulk Insert for the first time and have a question. I'm getting an error message about a field being truncated: Bulk insert data conversion error (truncation) for row 2, column 12 (Depleted) The data type for the "Depleted" column is Char(1). Looking at the file, there is indeed...more >>

On Win2000 or Win2003 you can use SQL Server 2000 Desktop Edition. On WinXP you must use only SQL Server 2000 Developer Edition. Which SQL Server 2005 I can use on WinXP? ...more >>

Hi, Am using robvolks crosstab-procedure to generate a crosstab query. I get this result: Total A B C juli 455 1 107 347 okt 83 1 9 73 aug 612 1 113 498 juni 451 1 108 342 So I get a total for each month. But I would als...more >>

I am seeing intermittent blocking problems. The strange part of it is, that the SPID listed in the Blk By column is the same as the SPID that is being blocked. Has anyone seen this before, or have any idea what this may suggest? ...more >>

Hello, I have a foreign key constraint between two tables (Appointments and MissedAppointmentReasons) and I'd like to allow null values in Appointments table for the field containing the MissedAppointmentReason, but currently, I get a Foreign Key Constraint Error when I try to add a record ...more >>

When using the MS SQL 2005 JDBC driver, I now need to have the DNS name resolution to the client correctly set up. If not I get the following error: SQLState: 08S01 SQLError: 0 Message: hostname : hostname Where "hostname" is the client host name. It doesn't seem to matter if I use an IP...more >>

Can i put picture in sql server database but not filename and path. I want to put complete picture in field in database. Is it possible? ...more >>

Can I convert .MDB file to SQL Server database or I need to develop SQL server database from begin, every table, every field? ...more >>

I have a database which stores documents (e.g. policies and guidelines) in our content management system. The follow relationships exist: Documents (1-to-Many) LinkTableKeywordLink (Many-to-1) Keywords Documents (1-to-Many) LinkTableAttachments (Many-to-1) Attachments Documents (1-to-Many)...more >>

please help newbie I need to create a lot of objects the same type (let's say: schemas) I wish to use paramerized block in loop to do so. - how to put names of my objects to such control-flow? belss you for help ...more >>

how to try-catch sp_addrolemember? ...more >>

Hi all. Running SQL2K SP4 on W2K3 Standard, SP4. I have just refreshed a database on one server with a backup from another. The database had existed previously on the target server, and I am just refreshing its contents. I used the following approach 1) From the target server, create a SQ...more >>

I need to test, wheather my scripts run under proper instance version (ie. if it is 2005). I only know @@VERSION, but taht's not it. Any suggestions? ...more >>

I'm writing a search for our site and I'm running into a few problems. When I run the query like this, it runs just fine: Declare @Keywords varchar(2000) Select @Keywords = 'modern trial advocacy canada' Select product_id, name, count(name) hits FROM estore_products INNER JOIN sequence ...more >>

-=-=-=-=-=-=-=-=-=-=-=-=--=-=-=-=-= -= Capital Radio - Chris Tarrant -= -=-=-=-=-=-=-=-=-=-=-=-=--=-=-=-=-= Capital Radio DJs have been "in on it" from the start. One of the first things I heard in the summer of 1990 was from a Capital DJ who said, "If he listens to Capital then he can't be a...more >>

I am pretty new to the subject...i would really appreciate if you could help me with this doubt... I need to write a C# code which performs the following: a) connects to the sql server database( I dont know the procedure to connect to the data base) b) on a web page i need to display the ...more >>

Hi I would like to know about connections of sa, where SQL store the number of connections ...more >>

Hi Everyone, I have a question about dynamically changing the length of a varchar(n) field, in case the value I'm trying to insert is too big and will give a "truncated" error, but before the error is given! i.e. Is there some kind of a way to "test" the length of the field while Inserting the...more >>

Hello The problem is need to find out the querry that has updated or inserted into the table and in turn 'Triggered the Trigger'. I have the user name, the machine name, Application name, but not the query. The update is not desired and the application is doing it but the application being so...more >>

Hello Folks, I have been compiling this new site www.dbahub.com, from a couple of weeks. I am trying to get most of the popular databases under one site, where all DBAs can find relevent information. I encourage to register with this website and submit documents, scripts, tips etc. and I will m...more >>

this is my query= "SELECT i.itemid,title,SortKey from Items AS i JOIN Links AS L ON (i.ItemID=L.ItemID) WHERE L.instructorID='12232' AND courseID='12' AND type='Audio' order by CASE WHEN Sortkey is not null then 1 else 0 end" My SortKey can be NULL. Here's the output I am getting: (the ||...more >>

Hi All, I am trying to write a basic stored procedure to return a range of values but admit that I am stumped. The procedure syntax used is: ALTER PROCEDURE Rpt_LegacyPurchaseOrderSp( @StartPoNumber PONumberType = 'Null', @FinishPoNumber PONumberType = 'Null') AS SET @StartPoNumber ...more >>

Hi, I want to run queries on a table that has binary fields in it. How do I filter on a binary field? E.g. One of the fields is called 'Account_Manager_ID' which is binary - I would like to do a simple Select * from company where Account_Manager_ID = 'blah blah blah' When I do this, it r...more >>

Hi, I'm working on a system migration and I need to combine data from multiple rows (with the same ID) into one comma separated string. This is how the data is at the moment: Company_ID Material 0x00C00000000053B86 Lead 0x00C00000000053B86 ...more >>

Hello, I wrote some complicated functions (and stored procedures) in database at my work. System administrator (and every db user) can view codes (in Enterprise Manager for eg.). My employer needs periodic modifying of code and so I'm required to do it. But I can loose my job :) because users...more >>

please, how to promt user in mu sql 2005 script? For example, I need user to confirm some operations.. . Thx in advance ...more >>

Im having problems with an after insert trigger... Im trying to join the INSERTED table with other tables to retrieve data....Some of these tables it must link to get data inserted into them at the same time my original table does...my question is why when the trigger runs, my sql statement ge...more >>

Hi Everyone, I=B4m new to this group, I=B4m trying to write a text files adding content from a text column (more than 8000 characters), I found code how to write files and it works but i have the problem when added the text column to the body of the file. any idea? tip?=20 thanks in advance...more >>

I recently setup merge replication and for each subscriber I add an try and synchronize I get the following error message: "The Process Could Not Log Conflict Information" When I view the details of the error it states the following: "The Process Could Not Log Conflict Information. (Sourc...more >>

please, in simple words, what is difference between : sp_executesql and EXECUTE in sql2005 ? ...more >>

which is more proper: if DB_ID(@db) IS NOT NULL or IF EXISTS (SELECT name FROM sys.databases WHERE name = @db) ? regards ...more >>

Can I define field names with more words in Access and SQL Server like field: "Bus station" instead "BusStation" or "Bus_Station"? I have had problems because of this in VB6. Can I have problems in VB 2005 or C# 2005 and SQL Server? ...more >>

Dear all, I'm designing a system including the database and the security represents the most crucial aspect of the system; hence for the database security i have implemented the following aspects and need your advise on further aspects or perhaps corrections where by the system is web based u...more >>

I'm using OLE DB model to insert long texts into ntext field. My code looks like : == BOOL COleDBRowData::Execute(CString strSQL) { if(!m_bIsOpen) return FALSE; CCommand<CNoAccessor, CNoRowset> rs; HRESULT hr = rs.Open(m_session, strSQL); if(FAILED(hr)) return FALSE; rs...more >>

How many users can access to SQL server at the same time with web aplication written in C# 2005? What if my database is 1GB and 1000 people access at 1 second - some simple query. My web hosting acc will be http://www.webhost4life.com or something simmilar! ...more >>

select distinct(f.agency+y.year+s.type) as SDNF In this select clause, I try to use the last 2 digit of year for y.year value. which function should i apply to it? ...more >>

Am I missing something obvious in the 2005 Visual Studio portion of SQL Server? I have a database design, with a bunch of tables, views, stored procedures, etc, etc. I want to store each object in a separate file, so I can keep them in Source Safe. Is there a command that will "rebuild" ...more >>

Hello, I've been reading about this topic, and I've gotten myself more confused, not less. We have a single-processor license SQL Server Standard 2005 (xeon 2.8 ghz) with 4 GB RAM in Windows Server 2003 SP1 Standard. I turned on the /3GB switch in boot.ini but not PAE or AWE, would it be go...more >>

Hello everybody, After several attempts of writing the query, I had to post my requirement in the forum. Here is what I have, what I need and what I did. Table A Col1 Col2 1 Nm1 2 Nm2 3 Nm3 Table B Col1 Col2 10 100 20 200 Table C Col1 (A.Col1) Col2 (B.Col1) 1 10 2 10 Ta...more >>

Hello! I am new to this group and I hope anyone can help me. I have an error message which is very complicated to me. Okay this message is very simpel, but I don`t understand how to build my SQL statement. I use MsSQL 2000 and I am new to Microsoft SQL. I have searched the web and read the on...more >>

Hi, When I run the following command on sql server: exec ('print "OK"') go This message appears: Server: Msg 128, Level 15, State 1, Line 1 The name 'OK' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted. Why? T...more >>

Hi, I have some tables where I import data in, lots of field have gotten a NULL value which the application can not handle. Now can I replace each NULL value with '' in a columns with: update <table> set [<column>] = '' where [<column>] IS NULL But because there are lots of columns this i...more >>

Hi! I have a batch file (.bat) that I need to execute inside my stored procedure (SQL 2000). I am trying to call that batch file using xp_cmdshell command. I am probably not using it the right way but I am trying to pass a path of the batch file into xp_cmdshell and it doesn't recognizes it ...more >>

I have one of our production Accounting Databases starting from 2 GB now grown into a 20 GB Database over the period of a few years... I have been getting timeouts when transactions are trying to update different tables in the database.. Most of the error I get are I/O requests to the data f...more >>

Hi All, I have a problem with a table that I want to get nice data out of in a single query. The guys here reckon it can't be done in a single query but I wanted to prove them wrong !! Essentially, I want to get the same column out of the single table, but in one case the column must have a w...more >>

Execute following T-SQL within Queary Analyzer of SQL Server 2000: ======================================= DECLARE @dTest DATETIME SET @dTest='2001-1-1 1:1:1:991' SELECT @dTest SET @dTest='2001-1-1 1:1:1:997' SELECT @dTest SET @dTest='2001-1-1 1:1:1:999' SELECT @dTest =======...more >>