Does anyone know what it means when i see some records returned that have their COLUMN value as NULL? I investigated a little to see if they are somehow related to orphaned users but I don't believe they are. What else would cause this column to be NULL? And it seems they are all MSP relat...more >>

DBA Interview Questions http://quickdba.blogspot.com/2006/05/dba-interview-questions.html Visit for more Articles ...more >>

Hi, We have SQL 7 running on Windows 2000 Server. For some reason we are unable to view Locks / Process ID from workstations running Windows XP SP2 with Enterprise Manager. Nothing shows up in the window on the right. All it's says at the top of the window is "There are no items to show in th...more >>

How do i close a current connection to a database using t-sql? I fail some time to drop the database getting messages that it's currently in use. Using the wizard to delete the database, i could check the option to close all connections to the db, but how do i do it using t-sql? best regards ...more >>

Sorry to raise a stupid question but I tried many methods which did work. how can I conserve the initial zero when I try to convert STR(06) into string in SQL statment? It always gives me 6 instead of 06. Thanks a lot. ...more >>

Oracle Server Quick Reference Guide http://quickdba.blogspot.com/2006/05/oracle-server-quick-reference-guide.html Visit daily to get more updated articles ...more >>

i have a table name is HH table it has two columns 'hhno' and hhname' HH tabele hhno hhname 100 suresh 101 baba 103 ram i want to insert a one record(102 , chandra) in HH table between (101,baba) and...more >>

I'm a really beginner about sql2000. During my test I have created the following query. It's works ok until I do't add the code included in section A, when I add it the i obtain the error: Cursor not returned from query Anyone can help me? Thanks Carlo M. set nocount on IF OB...more >>

I need to create an function similar to the "MATCH" function in Excel that evaluates a number within a set of numbers and returns whether there is a match. I have put the example of what I see in excel in the check column. The "0" answer in the result column is in the fourth account in the lis...more >>

I was playing around with the new SQL 2005 CLR functionality and remembered this discussion that I had with Erland Sommarskog concerning performance of scalar UDFs some time ago (See "Calling sp_oa* in function" in this newsgroup). In that discussion, Erland made the following comment about UDF...more >>

Dear All, How can I show the resultrecords of a SP. I can be done by doubleclick the SPname? But how to do it by code. I want the following interface In my form the user 1 selects a SP (combobox showing a userfrinly name) 2 adds the related parameters 3 and then click the show result-but...more >>

Hello, i am in a problem that i am having a table with 100 rows while i am presenting in report i want to limit rows to be 10 in a page in the report like that i want to get 10 pages .Please say me the procedure for this. Thanks, Baba. ...more >>

Is it possible to failover a single or a selected number of databases onto a standby server? We're currently log shipping about 12 databases to a standby and I was wondering if it was possible to randomly failover onto selected dbs. My understanding of log shipping is that when the primary ser...more >>

I am not sure If I can do this with a lookup, but what I would like to do is perhaps use lookup to retrieve a control date from an unassociated table to control what date is entered in another table. For example : the main table , table 1 has many entries with a field called date_ enter which ...more >>

Hello all, What does it mean when a field is part of an index? Thank you. ...more >>

When issuing the below command on any of our databases, it just hangs forever. ALTER DATABASE DBName SET READ_COMMITTED_SNAPSHOT ON; I realize that all connections expect the query window need to be closed and that is the case I think, or at least we are resetting the web server and still s...more >>

This script doesn't work. Why? UPDATE [460zz_Relma_Comment_Parse] SET [Comments 1] = LTRIM(SUBSTRING([Comments], 1, convert(bigint, CHARINDEX(',', Comments)-1))) WHERE NOT([COMMENTS] IS NULL) AND LEN([Comments]) > 8 Basically, I'm trying to move everything before a comma in...more >>

Could anyone help med with a select statement with a join between to tables. It is to be used in a OLAP cube. I Havde table LedgerBudget and Table Admin. In table admin I can setup a from and to date and also a budgetmodel. The admin have ONE record per OLAP cube. The statement below works fi...more >>

I just installed IIS on my windows xp pro machine and when I try to access a website on the local IIS server, I get the following error message: "You are not authorized to view this page" I have enabled "Anonymous access" inside Directory Security option of IIS and I also granted full NTFS p...more >>

I am running windows xp pro on my home computer and would like to test an database driven ASP .NET web application. I need to be able to create an SQL database which will be assessed by the web application. I already have a local IIS Server up and running. At work, I use SQL Enterprise Mana...more >>

Hello, Using SQL SERVER 2000 I have 4 columns with varchar(80) each that I want to concatenate. When I look at the result, it only gives me 256 characters. What am I missing on my code? Select Cust_Number, Info = convert(varchar(1000),rtrim(line1) + char(13)+rtrim(Line2) + char(13)+ rtr...more >>

Hi. I have a SP named, for instance, SP1. I need to execute something like SELECT Sum([Field1]) FROM SP1 WHERE [SP1].[Field1]='0' and I get the message: Server: Msg 208, Level 16, State 3, Line 1 Invalid object name 'SP1'. However, SP1 *IS THERE* and runs fine !!! Thanks Alex ...more >>

Hi, i have a table with 3 ints that are used to store dates. The datetime data type is not used because this data comes from an old AS400 server. I need to be able to use those 3 columns to build dates within a query and be able to use them to compare themselves to other dates Let's say the...more >>

I am an oracle savvy developer looking to switch to SS. Know of any good books that compare/contrast the two? Thanks ...more >>

New to Sql Server, running SQL Server 2000. Our transaction log file backups occasionally fail as the size of the transaction log gets really huge. We'd like to schedule additional transaction log backups. Does that require an exclusive on the database or can the db be used during a transactio...more >>

hello all, is there a quick way to convert a zipcode of type int, to a 5 character char value ? e.g. declare @zip int declare @czip char(5) select @zip = 2109 select @czip = convert(char, @zip) select @czip but with @czip = 02109 instead of 2109 ? thanks in advance ...more >>

I have a user that I have granted the server role "security administrator" and a database role "db_securityadmin". When logged in as this user I can create new logins but not run sp_adduser to add the new login to as this says I don't have permission to do this. I can however run sp_revokedbacce...more >>

Hi, I have to convert an MySQL database into a ms-sqlserver database. Anyone know a software (is is possible freeware or not so expensive) to translate database? I have only to translate tables, no triggers or stored procedures. Or anyone can send me a link to a web site about this problem? T...more >>

My name is W. Curtis Preston, and I'm the author of "Backup & Recovery" (formerly "Unix Backup & Recovery") from O'Reilly & Associates. (http://www.oreilly.com/catalog/unixbr/ ) We're updating the book for 2006 and adding a chapter on SQL Server backup and recovery. Someone has already writte...more >>

I thought I'm pretty good with sql. Was presented with a little challenge the other day, a colleague asked me to create a parent to child relationship for a table without changing db schema. The table looks like this pkID parentID altPKfield 1 null abc 2 1 ...more >>

Hi, does sb recognize (aspects of) the following problem? Or better, know a solution or direction to search? At work I've inherited a series of delphi applications that access a common database using SQL Server 2000 (sp3, sp4 update in preparation due to this problem). Applications run on ...more >>

Hi, I have the following stored procedure that does some processing and puts the result in a temporary table. I tried several things that procedure to display output that I can access with ADO.Net, but it doesn't work. It doesn't even display the result in the query analyzer unless I add SELECT...more >>

Hi , What i exacly want to do is 1. Connect to OLAP server from my Sql server using following query string 'SELECT a.* FROM OpenRowset(''MSOLAP'',''DATASOURCE="RAPID-CHRISTUS"; Initial Catalog="MRS"; 2. I want to execute my dynamically created MDX query . This query can be greater...more >>

Hi, Does a database restoration perform any update-statistics/defragmentation by default. We observed a marked improvement in performance when we restored the a database from an high end machine to a low machine. Could someone shed some light on this. Regards, Thyagarajan Delli. ...more >>

i have a table gg. It has two fields one is ggno int, ggfig image . how can i insert into the record into 'gg' table help me with exampple ...more >>