Hi All, I'm currently using SELECT * FROM sysobjects WHERE xtype = 'U' ORDER BY name ASC to extract all table names from a database. How do I find the table owner (as there are multiple tables with the same name, but different owners) TIA Bill ...more >>

Hi, Our developers have just installed sql 2005 express on our sourceserver. When i try and back it up using netbackup 9.1 I get the following error. "an error was encountered while attempting to browse the contents of <servername> a network connection to the server could not be establi...more >>

Using SQL Server 2000, I need to construct an sql statement inside a stored procedure as below... SELECT TOP 1 @SelectedValue = Value FROM MyTable .....however, the tablename is not fixed and so I need to build up a sql string and then call it using the EXEC() function...... DECLARE @Se...more >>

Hi all, Just got a server running SBS 2003 R2, fully patched. New from Dell. I notice that there are 3 SQL instances already installed and running (WSUS, SBS Monitoring and SharePoint). However, there is no GUI connectivity installed and I cannot connect with osql also. I know they are SQL ...more >>

How can I find a piece of data any place within the database? All I know is that the string 'ABCDEFG' appears within some column in some table in a known database. Is there an easy way to scan the entire database and identify the table or column? The hard way is to write a dynamic SQL sta...more >>

Does anyone have any experience setting up SQL server with the data stored on an external (USB / Firewire) hard drive. This setup would be used by 1 or 2 users for data analysis, it would not be intended as a production server. If anyone has tried this, I am interested in any idea of what si...more >>

I have a Dell Dimension 2400 with xp home edition on it. I want to get rid of this SQL server thing. When it doesnt connect i cant get on the internet or anything and then everything runs so slow. then It causes nothing but problems. Will my system still run ok if i erase this? Is there anyth...more >>

Hello, Does SQL server implcitly maintain the timestamp of each inserted row? I have few tables in my MSSQL database and I don't have any timestamp fields in the table. However, I still want to find out the time at which rows were inserted in the database. Does SQL provide any implicit way ...more >>

This should be a simple thing but it is proving very difficult. I didn't install the AdventureWorks database when I installed SQL Server 2006 Standard Edition. I now want to install it. I have done everything that Microsoft recommends but still no database. Here is what I tried: 1. Tried to...more >>

I have been cutting and pasting sprocs in an ADP-- seems like a pretty natural thing to do. I am signed in as 'sa'. I'm confused about why this statement returns the wrong DDL? ----------------------------------------------------------------------------------------- sp_helptext 'QA41_Ad...more >>

I have a chunk of code which is essentially IDbCommand cmd = db.CreateCommand(); cmd.CommandText = "SELECT X, Y, Count(*) FROM Foo WHERE Z = 1 GROUP BY X, Y"; using (IDataReader reader = cmd.ExecuteReader()) while (reader.Read()) { // grab values from query } The database is...more >>

Hi I'm hoping that somebody can help me with the following problem. To simplify things, consider a table that only has two fields: a primary key and a field that holds a string. What SQL can I use to see whether the table contains duplicates i.e. there are rows which hold identical valu...more >>

Hi, Is there a news group dedicated to Reporting Services or one that I can post my questions. Thanks ...more >>

Team; I've got a string like 'hello world grandma' and I want to find or write a UDF that will tell me the longest WORD out of that string (in other words, grandma).. i'm using SQL 2000 of course :) -Aaron ...more >>

Hi I can't get my sql 2000 to connect again since i installed 2005 now i uninstalled sql 2005 ctp but i still get the error about 2005 not being configure for remote connection when trying to connect to sql 2000 how can i remove 2005 ctp properly by the way i tried to reinstall 2005 ...more >>

Hi! Thanks for even reading this :) I have a table called PeopleType, which is just ID, Name, and Description. I have another table called Event, which is ID, Name, Description, and Date. I just made a third table (I call this a "mapping" table... what is it normally called?) called Even...more >>

hey I work in a SSRS environment; I also do some web dev.. and we keep on having authentication problems getting a token to pass from one user to the webserver; and then to the database server. this is called 'double-hop' authentication.. right? I'm of the understanding that I need to che...more >>

SQL Architecture Opinion > > Hello. I am looking for your opinions on an architecture solution that > our System Architect came up with for our SQL Servers within our IT > division. Essentially, his idea is to implement one large SQL Server > that all databases will run off of, regardles...more >>

i've got an ssis package that runs fine when i run it from within visual studio, but fails when run under sql server agent. when i run the package from visual studio, i'm logged in under the same account as the sql job's owner (both the admin account). the step it's failing on is when it needs...more >>

Hello, I am trying to write a stored procedure where it performs an update and then returns a couple of fields back to the ASP page. Below is the SP code... CREATE PROCEDURE dbo.p_update_asset @asset_code varchar(20), @newsort varchar(20) = NULL AS set nocount on DECLARE @rowco...more >>

First off_ pure - uneducated - hacker - novice - alert!! If you are offended by silly questions close this posting immediately! I'm sure this has come up 1,000K times before and I have googled the issue_ Still have not found a satisfactory explanation. I have a table 'alarms' with several d...more >>

Hi folks I have a table with a primary key. My central goal is to improve the speed of the select using the primary key (that is the only query II care about.) It is ok to sacrifice the performance of the insert into the table (insert happens once a day when there is no activity on the table). ...more >>

Hi, I'm using SQL 2005 encryption, and would like to create a view that (in addition to selecting data) opens the symmetric key used for encryption if it's not already open, and leaves it open. I know I can use DecryptByKeyAutoAsymKey to automatically open the key, decrypt the data, and then ...more >>

Hi I'm hoping somebody can help me with the following problem: I have a table which has several fields holding floats. These floats need only be stored to 3-4 decimal places, however, as far as I can see, the floats in sql server 2000 have a precision of 53 - far too much precision. I'm...more >>

Hey I am currently working on at project. where I have some "problems" regarding to the way the SQL Express is Working in general. My setup and goal is the following Setup VIA 700Mhz processor 512Mb Ram OS XPe with SQL express and my shell my goal is to get the SQL Express to run as ...more >>

Hi guys, need your help. i've no knowledge of DB. i gotta create a script, in that i need to check for a column in the table, if the column doesnt exists then i need to create a column. i tried this code in my script for checking the column: go if ((SELECT COALESCE(COL_LENGTH('Table_name...more >>

How can I find the foreign keys for a table? I would like to be able to find, for any table, the columns that are foreign keys and what tables/columns the foreign keys are related to. Basically what I am trying to do is this. My developers want to allow logical deletes of data. I don't want ...more >>

Hello folks I am new to Sql Server database and I have a high level design question that I hope you guys can help me with. In sql server, what are the advantages or disadvantages of separating different applications into different databases. An alternative could be to share the same database ...more >>

Hi, I have a smalldatetime field in my table and when I do a query, I would like to output the date with weekdays, ie: Tuesday, October 10, 2006. How can I do that? Thanks in advance! ...more >>

Hi, I need to calculate grand total of only visible rows data in my report. I dont no how to avoid those hidden rows values from the calculation. Any help? Many thanks. Munnu. ...more >>

I have a problem that seems to be similar to the issue fixed in MSKB article 922804 (http://support.microsoft.com/kb/922804) We are an ISV and our application uses a separate reports database fro each user. When a user logs in, if they do not have a reports DB, we create it. When they log out ...more >>

The development of an application that handles encryption of data stored in a database (SQL server) at the application level. This is what I am trying to develop, but I am just in a researching face for the moment, hence my question. Can anybody reply me on the how difficult this should be to ...more >>

Hi there, How can i convert a 04/01/1920 to DDMMYYYY format eg. 04011920? ...more >>

All, To start off I have SQL 2005 SE Clustered in an Active/Active environment. Everything is working correctly as all websites and standalone applications are connecting and getting/sending data correctly using SQL authentication. My problem is that I have 1000's of developers that would l...more >>

Hi Guys, I'm trying to deliberately create a DB corruption (QA reasons) on one of my DBs (never mind which one, even the System ones will be ok), on SQL 2005 Ent. edition. Since I'm kinda new in the area, I'd appreciate any help you have to offer (query, etc...) Ps, I need to corrupt th...more >>

I have 2 transaction log physical files on M and N drives (dbname_log1.ldf and dbname_log2.ldf) and I want to have only one physical log file on the L drive - how do i remove/rename/delete/create the transaction log on a new device thanks shane ...more >>

http://www.treas.gov/offices/enforcement/ofac/sdn/ I wonder if it my be conceivable/practical to import on a regular basis, hands-off, the XML version of this list directly from it's source, the web, to a MS SQL database, in this case version 2K? Thoughts, ideas? ...more >>

Hi I'm brand new to SQL and have finally (with much support) managed to get values from an Excel workbook updating a live SQL database using the following: sSQL = "UPDATE Clients SET [Org Commission]=' " & Range("F38") & " ',[PPP Amount]=' " & Range("F36") & "',[Org Amount]=' " & Ran...more >>