We have been using MS Access databases to do all of our data collection for all areas of the company. We have approximately 15-20 different Access Databases, all with web interfaces using ASP pages. My question is this. We have SQL Server 2000 installed on your web server for our content mana...more >>

I have forums installed on one database, and a multiuser blog system on another database. I was wondering if it was possible to synchronize the databases so that the users' logins and passwords would be the same on the blogs as on the forums. If so, how would I go about doing that, without using...more >>

Hi, I have 2 servers, both with Windows 2003 Standard edition. Servers are NOT in a domain. The second server has SQL 2000, the first has IIS 6.0 Through OBDC (System DSN) I created a connection to the SQL db. Then on my laptop I opened up frontpage to create a page to view the db results. ...more >>

Hi experts :-) ! What i want is a stored procedure or query or whatever that lists all databases and their size.... And the sizes of all the tables in that database so i will get a report like: Database 1 > 100MB table1 > 10MB table2 > 90MB Database 2 ...more >>

Is it possible to edit data in a SQL table with Excel? I want to "open" (not import) the table from inside Excel. Regards Anders Sneckenborg SIMBAL syd AB ...more >>

No one knows how to architect a system like me, but I keep running into so called experts who state their opinions as facts and take the time to dare question my knowledge. Some examples of the right way to do things. If there is a performance problem in a few large databases, break them in...more >>

What is the most efficient way of inserting new data into table with duplicating data that already exist. insert into table2 (fieldname) select field1 from table1 where field1 not in (select fieldname from table2) works BUT what if field1 is a varchar(255) and there's a couple of million ...more >>

I have an Oracle (8i, I think) linked server set up in my MSDE 2000 server. I use openquery to execute procedures and return results. My front-end application calls a SQL Server stored procedure and gets a recordset, it doesn't even know that Oracle's being called. The system works fine, the...more >>

Hi, is this somehow possible: select myFld, (exec spMyStoredProc @inputVar1, @inputVar2, @outputVar = @myVar output) from myTable When I run the query above I currently get this error msg: Server: Msg 156, Level 15, State 1, Line 6 Incorrect syntax near the keyword 'exec'. Server: Ms...more >>

I have just installed SQL Express 2005 and have no tools to directly manage the server. Is there supposed to be tools to be able to manage and run queries (much like enterprise manager and query analyzer in SQL 2000). Thanks, Scott ...more >>

One of the tables returned by "sp_help [TableName]" contains the foreign keys and which fields are affected by it. The problem is that it only contains the "parent" foreign keys. I need to know the child tables that reference the current table. I've been playing with the sysobjects, syscolu...more >>

Hi, I've been trying to run SQL mail on my remote server... I'm running the SQL server and agent by one userID and I have an MAPI profile for the same user... my sql agent is set to use the same MAPI profile... mails are going out and being received by the intended recepients fine... Howeve...more >>

Hi All, I was wondering if someone had a better solution than what I have seen. When performing calculations on integers SQL Server sets the data type of the result to the data types of the input.... So if you divide 25 by 100 and the fields are integers you get 0 not ..25. The solution I ...more >>

Hi, I find myself spending a significant amount of time trying to write SP (and application code) to interact with simple stored procedures used for inserts, updates, etc. I found something called the "Stored Procedure Wizard" (Which I'm downloading now).. HOwever, I was wondering if somethi...more >>

Does any one know how to convert an ordinary integer column to an "int identity (0, 1)" column via T-SQL? ...more >>

I have an order system, pretty common db structure (order, lineitems, customer, customer addresses), and I have a common simple search.. %Last_Name, X%Last_Name, First_Name% (to give a few examples). The customer address table has just a full name field that the wildcard searches are often...more >>

Hi, is it possible to link Exhange and SQL Server together so that i can run queries on public folders, like i do tables? Thank in advance Mike ...more >>

so i have a couple of tables that are joined via mdb odbc linked tables.. they keep on trying to lock the tables.. and this is causing replication to fail to these tables i believe that the table is only 10k records; but it recieves 20k updates per hour.. (it's fairly wide) i keep on get...more >>

Not a biggy this one but abit of a pain. When you run a sp as a batch will print commands as part of the sp for debugging the results in the messages pane buffer up and all display when that buffer is full. Is there a switch or something in QA that will force messages to be displayed as the...more >>

My HP ZD8000 laptop with MCE2005 pre-installed just arrived this morning and I can't seem to get SQL Server to install. The version of SQL Server I'm trying to install is SQL Server 2000 Standard Edition, which came with the Microsoft Action Pack my company ordered. When going to install the...more >>

so i have this table that has maybe 100 columns; when i connect to it via an ADp it only shows like 15 of the 100 columns all the columns are decimal and char.. it's not like this has changed recently or anything.. im just confused about why it's showing the table incorrectly ps - i have on...more >>

Just checking to see if anyone else had an answer for this: I've got a Crystal Enterprise Server that connects to an Active-Passive SQL cluster, while applying patches we noticed that when we fail over the node, the CR server hangs like a big dog. Anybody experience this before, we actually ...more >>

hey i work for this company where they have like WAY too many paranthesis in their join clauses.. i mean.. should these be used in like 1/3 of the queries; or like 80% of the queries? Basically they have views like this ------------------------------------------------------ SELECT tblAMH....more >>

Hi I need to do a strange compound query but I'm not sure of the syntax to use and wonder if someone could help..... there is a table called categories [categoryid int identity, cateogryname text] there is a table called products [productid int identity, productname text, product money, du...more >>

When I have a big changescript, sometimes I have to add more then one new trigger, so the "create trigger" parts colud be somewhere in my cahngescript. But tehn I get the error I've posted as title: "Server: Msg 111, Level 15, State 1, Line 4 'CREATE TRIGGER' must be the first statement in a qu...more >>

What is the correct way to code the following assuming you wanted to copy all roles for user with a UserID of 1 to a user with a UserID of 9? EXAMPLE: INSERT INTO tccUsersXSiteRoles (UserID, SiteRoleID) Values (9, (Select SiteRoleID from tccUsersXSiteRoles where UserID = 1)) ...more >>

I am looking for a way to print the database design (SQL Server 2000 Developer Edition). How can I do this? Regards Anders Sneckenborg ...more >>

Hello We have developed a SQL Server database on our machines (created using Access Project). We have set up users and security and primary keys and timeouts and that sort of stuff as well. This database is the backend data store for a front end application we have developed, i.e. the SQL Se...more >>

Newbie here, When I execute the query: SELECT TPRD From tblCurrentMonth it returns the string 200507 which is what I am expecting. When I put the query into a stored procedure, the sproc executes without error and returns NULL. This is my stored proc: ALTER PROCEDURE [dbo].[sp...more >>

Hi, I want to figure out (dynamically) how many columns a sql statement will return, without executing the actual statement, i.e. Say I have the statement "SELECT * FROM MYTABLE". Can I wrap this with another statement that gives me the count of the columns, without executing the possibly long...more >>

Hi, I'm using windows Sharepoint Services for my application. This sharepoint site contains One Database. In this database one table called Docs Table is there. In this Docs Table i have written Insert,Update and Delete Triggers. Problem i'm facing: When i insert any row in this ...more >>

I have a database that has been marked suspect after SQL server hung while importing data from excel. I have tried sp_resetstatus which says that it has forced the flag from 256 to 0 but I'm not sure if actually has or if the flag sets itself again as soon as I try to access the database. I...more >>

Hi everyone here is the scenario, i upsized my access database to a SQL 2000 server and everything works fine for sure my forms wouldn't be upsized, all i want to do is make employees access the database using interface, something like forms, and as i don't know VB i couldn't make that to happe...more >>

when i Click the Start button, select Programs -> Microsoft SQL Server -> Analysis Services Analysis Manager, and expand the Analysis Services folder in the Console Root. Right-click the server and choose Migrate Repository. i get this error : Could not find stored procedure 'Server' ...more >>

I created table metadata using INFORMATION_SCHEMA, IDENT_INCR, IDENT_SEED and so on. But for some reason I need to store the description of the table. I couldn't find any system table that store table description. Does anyone know how to get this property from SQL Server internals? Serguei ...more >>

Hi, first I've used google to search this archive for an answer, either I'm not using the right keywords or the question's not been asked. We have a dts package here at work that populates a blank (actually an empty db copied from a model) microsoft access database with data from tables in an ...more >>

If memory is not a factor, which is faster: querying for all the fields in a table or querying for a subset of fields? My initial guess would be to only grab a subset, but would this take longer on the DB side or not matter? Thanks. ...more >>

I'm working on asp .net project,when trying to work in debug mode IE stuck(not responding). When I debuged it I saw it stuck when trying to connect to the sql server. After that when I'm trying to open regular IE window it's stuck also . After restart when I'm opening the same page not ...more >>

Hi folks! I am wondering if anyone out there has been able to use the NOT FOR REPLICATION field constraint when implementing a manual replication process? From what I have read, only the inbuilt replication methods can actually insert identity fields without SQL Server happily updating it's i...more >>

I am getting ready to install a new sql server at one of our other locations. While our main location sql server has thousands of transactions per day, this new one will, at most, have a couple of hundred. do I really need to install the Veritas Agent for SQL server on the new one, or will pla...more >>

Folks, I'm wondering can you help me please. Using SQL Server 2000 how do you make a copy of a certain database either by using a coding approach or using a GUI menu or both. Say, for example, you have a database called "A" and you want to make an exact copy of it called "B" for example to ...more >>

This insert was working. Here's the whole thing, including error msg. I stretched out the insert statement to see if the "Line 1" error message would change, but it did not. INSERT INTO Companies (compName,compAddr1,compAddr2,compCity,compState ,compZip,compPhone,compFax,compEmail, compWebsit...more >>

I am encountering weird behavior, and I wonder if it is well-known, if it is a bug, or if it has a purpose of some sort. In a stored procedure with output parameters, if a NULL value is returned for an output parameter, all output parameters AFTER that output parameter will be DEFAULT (or NULL...more >>

I heard from one of our prod dbas, after he'd been to a TVP seminar, that yukon's got an Oracle sucker. (Ie. sucks the whole schema, and data into SQL Server.) Is this true and where is it? ...more >>