Hi. I need to move some tables to a separate database. Is it possible to create a relationship between two tables in two different databases? Thank you. R a a n a n . ...more >>

Hi, I am designing a tree structure in my database and I found nearly the perfect solution to my problem at http://www.intelligententerprise.com/001020/celko1_2.jhtml The only problem is I can't get it to work (at least not perfectly) in sql server. I am basically trying to produce a nested...more >>

Is there a Query to find the licesnse scheme that SQl is using? Per procesor or per seat and does it give a quantity? If not I have an NT SQL server7 that says per seat and doesnt give a count. Trying to find the count of all SQL licenses in my enviorment. I the little applet in the control ...more >>

Sir, I am a little confused. I have an asp.net application, it is a forum site, in order to have a page navigation, I need to get the value of how many pages in total. I used a stored procedure to do this job. However, I found out that this sp always takes about 10 seconds to execute according...more >>

I'm writing an app that can be used with some modifications in different markets. I can vary the differences in the app using .ini files, registry entries, etc., but I'm not sure about whether to create a new database design per industry. The current design has approximately 20-30% of the tables...more >>

Pretty simple I am sure. I ahve a table with comments and have commented all the columns. I am trying to create a view that renders the following columns TABLE, TABLE COMMENT, COLUMN, DATA TYPE,LENGTH,COLUMN COMMENT. What I have is way off... any help would be appreciated. Laurel S...more >>

Hi, What do you thing? Is it better every tbale to have Primary Key or it depends on something? I have a table SearchTBL --------------- UserID(FK to UserTBL) EstateID(FK to EstatesTBL) Pice Romms Floor Do I have to have a Primary KEY? And also if I use Primary Key in general m...more >>

Hi again... For a user and a list of dates, I need a count for each date for each table where the tables are donordonations, donorneeds, and donorgifts. The output would be something like this: Productivity Report User: Joe Date Range: 1/1/04 to 1/3/04 Date Donations Prayer Requests ...more >>

Hi All, I seem to be stumped at the moment, All I would like to do is join a Customer Name field (CHAR) with a Customer Number field (FLOAT) to get something like this "Joe Bloggs - 998477771". When I try to do this the CONVERT or CAST function stuffs up my FLOAT field giving me strange ...more >>

Does anyone know of a way to discover before and after values in a AFTER UPDATE trigger when the primary key has changed?? I need this to work with multi-rows too! I'm familiar with the 'inserted i inner join deleted d on i.pk = d.pk' technique for seeing 'before' and 'after' values, but of co...more >>

Hi! Is there a good way to pass a column name to a UDF and use the column name in the SELECT statement in the function? Because I cannot use EXECUTE in UDFs like below, I don't know how I can do it. CREATE FUNCTION dbo.myfunc(@columnname nvarchar(100) ) RETURNS TABLE AS RETURN(EXECUTE('...more >>

Hi all! I have a problem with implementing something....Actually I realize what I want, but it is too complicated. My DB looks like that: UsersTable ------------ UserID(PK) | UserName | Password | Name | Addr | E-mail | UsrType | Role | LastLogOn EstatesTbale ----------- EstateID(PK) ...more >>

Using MS SQL Server 7 I have a long running query which joins two tables with a group by. These tables have millions of rows. Any insert to the tables in the query will become blocked until the query ends. 1. How do I avoid this kind of blocking? 2. Will an upgrade tp SQL2K help? ...more >>

Hi all, I am currently using a Win32 API call to NetServerEnum to enumerate all SQL Servers on an NT Domain. The function returns the names of all servers running SQL Server on the network, but it doesn't return any SQL Server/MSDE named instances. Does anyone have any ideas on how to enumer...more >>

Hi all, Does anyone know if there is an XML DTD or XML Schema for DSNs? Specifically I'm writing an app to export ODBC DSN settings from the registry to an XML file. I can easily create my own DTD, but obviously don't want to reinvent the wheel... and if there is a standard out there that wi...more >>

Hi, I want to be able to send emails out to users. We're developing our app in ASP.NET using SQL 2000 however, is there any way to have the template (for the body of the email) reside in the DB but have ASP.NET parse the template? For example: DB - Hello [firstName]: Thank you .... A...more >>

Thank you for the reply, David! My DB looks like that, because I have one more table : SearchTable ----------------- EstateID(FK) UserID(FK) MinValue MaxValue ParamID(FK) and the others: UsersTable ------------ UserID(PK) | UserName | Password | Name | Addr | E-mail | UsrType ...more >>