Hi, I need to remove list of tables from all views There are cca 100 generated views and each is using many tables, as input of my stored procedure i have table name and i need to: 1. delete this table (solved) 2. delete usage of this table from all views (problem) ---------...more >>

I installed SQL Server 2005 Developer Edition and everything was working fine. One day, I launched SQL Server Management Studio from the desktop and received the following error: "Package 'Microsoft SQL Management Studio Package' failed to load." I receive this error every time I start the Ma...more >>

I'm assisting someone who started having trouble with most of their scheduled SQL jobs not running after they moved their server to a new location/plant. As a side note, my understanding is the servers belong to their own domain so this move should not have affected things too much. Further...more >>

Hi, I want to check for the existence of a table in my SQL Express database and check that it contains the correct columns and possibly create it if necessary. I know there are restrictions in the use of system stored procedures in SQL Server Express Edition but can I do what I need to? I'm...more >>

I have a promotional set of three microsoft titles of software (Ready to Launch) which were handed out at a Microsoft event. One of these is MS SQL Server 2005 Standard with 1 CAL. I don't find anything in the EULA, so is it legal to install, register and use this promo version in a busine...more >>

I have a linked server to a Universe (pick) database using SQL OLE DB for ODBC and a Universe ODBC driver. The SQL queries I use return small amounts of data from small tables on the linked server and the queries are such that the linked server does all the work. Performance, however, is poor...more >>

Hello, I am trying to copy user logins from one database to another on the same instance of SQL. I used DTS to export the data to the new database, when I should have used the backup option. I'm in a bet of trouble. Now the users can not access the copied database. I followed the suggest...more >>

I'd like to report to the user when the server was most recently rebooted. Is there a stored procedure or SQL Server 2000 command that I can issue? ...more >>

How do you do a binary search ...more >>

Hello, I have a hardware configuration question. If this is the wrong group please let know. The system uses MS SQL 2000 Enterprise to store all of the data. The data comes from a as web server (IIS 6.0, Win 2003 Server). The currently proposed solution comprises 3 different...more >>

People are telling me it is bad to put select * from <atable> in a view. I better should list all fields of the table inside the definition of the view. I dont know exactly why but some say: A select * from makes sql server does a table scan. Is that true, even if i put a where...more >>

Hello all, I have the following t-sql batch: create procedure stp_test ( @p_date1 as datetime = null, @p_date2 as datetime = null ) as begin set @p_date1 = isnull(@p_date1, <some expression>) set @p_date2 = isnull(@p_date2, <some other expression>) select ...more >>

i've downloaded the new sql express, but i dont see how to get started entering the raw data for the database. i mean, where is the interface for typing in the records into various tables? mike g ...more >>

First time I am using sql server 2005. What is the default server name???? I can not see anything in managment studio. whenever i tried to connect OR create database through SQL sever Management studio, it asked me: server type: (here i select Database Engine) server Name : ( ??????????)...more >>

Hello, I want to use SQL Server Express 2005 as the database server for a commercial web site. Web site users will have both anonymous and non-anonymous access to web pages on the site (generated from data in the SQL Server Express database). Is this kind of use within the EULA of SQL Serv...more >>

Howdy. Any suggestions on how to coax two counts out of a single SQL statement? Problem: I've got a request table with statuses, timestamps, and other fields. I need summary counts of recent (say, in the last week) and total requests of the various status values. What I want: Status ...more >>

Hi all - This may be a really simple thing, but I am stuck... I am running SQL Server 2000 and I am trying to basically dump a table to a delimited file each evening around midnight. Is there a way to easily automate this? Thanks in advance! Timothy ...more >>

Hi everyone: I just want to verify that I'm correct (or at least on the right track) with what I'm doing. I have a stored procedure that needs to see if a table contains a row with a certain value, if it exists, I want to update it, if not then create it. I want to ensure that if the row is...more >>

I get the following errors a couple of times a day and I want to make sure I understand what it's saying. As it states in the error, SQL Server "Failed to reserve contiguous memory of Size= 15990784." So it was unable to reserve 15 MB of contiguous memory, correct? As I understand it since thi...more >>

SQL summed output as percentages question Hi I have a record set of the following form: APPLE APPLE BANANA BANANA BANANA BANANA ORANGE What I would like to do is return this record set in the form: APPLE 28.57% BANANA 57.14% ORANGE 14.28% Is this possible to do this in SQL (p...more >>

Moving to a new blade server that will require me moving my production DB to the new server. I've never done this before but it seems to be pretty straight-forward. Any tips I need to now for the switch-over? Thanks to anyone with help. ...more >>

Hi, I've been working with SQL for a few months now...some db design and a lot of scripting. I love it! Been thinking about the UW Certificate course in Database Administration. Anyway, I am looking for SQL user group in Seattle. If not Seattle, I suppose I'd give Kirkland/Bellevue/Redmon...more >>

I've got a question; i've got a view hitting against a subquery and it takes forever its like-- do i need to bind the subquery to the view in order to get better results? --TAKES 90 SECONDS SELECT * FROM vwSelectFolder WHERE FolderID IN ( Select DISTINCT FolderID FROM FILES WHER...more >>

The DTS package runs fine through Enterprise manager successfully. However, when scheduled through a job that runs the dts through the following code: DECLARE @findfile int Exec @findfile = master.dbo.xp_cmdShell 'dir \\ServerName\folder\filename.xls', no_output IF (@findfile=0) BEGIN Exe...more >>

Did MS miss object type (User/System) or am I blind as a bat? Select * From INFORMATION_SCHEMA.ROUTINES ... I don't see it. ...more >>

Can I send a parameter string value to a stored procedure for IN clause values ? ex. CREATE PROCEDURE Procedure_Name @Param1, nvarchar AS BEGIN SET NOCOUNT ON; SELECT * FROM COUNTRY WHERE country_no IN (@param) END If not, is there another way appart from creating SQL on runtime ?...more >>

A newbie SQL server question. This is SQL Server 2000. If I create a new SQL user, and give them db_datareader permissions to a database, I understand that they then have permissions to do a SELECT on any table in the database. If I then view the properties of that user on the database its...more >>

In previous versions of SQL Server, the Database Maintenance Plan would give the backup file a new name (date and time stamped) every time the backup ran. In SQL Server 2005, it appears that a file name is generated the first time the backup runs, but after that, all existing backups are append...more >>

Hello all, How can I use two tables in explicit mode: use company_table select 1 as tag, select 2 as tag, null as parent, firstname_employee as [employee!2!firstname_employee!element], job.jobid as [job!1!jobid!element], jobname as [job!1!jobname!element] from job join employee on jo...more >>

Hi, I'm wondering if anyone else has encountered this issue? I have installed sql 2005 (developer edition) to a named instance on my WinXP Professional box. I can access the instance via VS2005, but when I try to open the Server Management Studio, the interface simply hangs. Anyone else exp...more >>

I've got a simple site stat collection database consisting of 4 linked = tables: =20 Sites - contains name of site Pages - contains name of page, with a foreign key into the=20 site table, indicating the site to which the page belongs. Visitors - contains unique visitors ...more >>