I want to backup a SqlServer Database on a schedule (database:: MyData, (nightly)). It appears you can do this using the management wizard in SQL 2005 standard but not in Express. Is there a work around for SQL Express? Thanks Ed Warren ...more >>

How do I edit the recent projects list. I may create test projects, etc that I do not want to appear in that list. Thanks. jay ...more >>

When I installed SQL Server 2005 it setup a folder for projects in "SQL Server Management Studio" which by default is in My Documents. How can I change this location? I have looked in the typical places (Tools | Options), etc. but cannot see anything. Jay ...more >>

We have been using the 'Copy SQL Server Objects' with success for some time to copy an entire database to another server. Recent changes to our database infrastructure cause DTS to fail: 1) We have a check constraint which uses a user function (which refers to the table on the check constrain...more >>

Can I keep bookmark persistently? I mean I can set bookmark by using Microsoft SQL Server Management Studio, create Folder for bookmarks or rename bookmark. However, can I save the informations for all bookmarks so that I will see the bookmarks next time I reopen Management Studio? ...more >>

Hi, In isql docs, I see and example : isql /Q "EXIT(SELECT COUNT(*) FROM '%1')" How should I interpret it ? Where are these percent-parameters documented ? In fact, I am looking for a way to pass some parameters to the script executed by isql, be it through environment or ...more >>

I have developed a winforms DotNet application which has been tested for performance and concurrentcy with a few clients on a small MSDE engine. But I've never done any real scalability testing. The application will go live with about 50 clients to begin with, but likely to multiply 10 fold so...more >>

Cannot figure this one out. I installed 2005 Express, and can create a new db just fine. But I want to copy a full db, which has 40-something tables, from a SQL 2000 instance on another machine. If this was 2000, I'd just right-click and select All Tasks-->Import. But 2005 has no such optio...more >>

OK, I understand that a table with a single row IS a dictionary. Actually that's how my app stores its globals right now, but predictably this row is getting unmanagably long. So I was thinking it's time for a do-it-yourself dictionary table, what I had in mind was a key column (VARCHAR), valu...more >>

Can anybody recommend an instructor-led class or training organization in SF? Boot camps or 1 week training are good. Thanks. ...more >>

Hi, I had used MS Access with my application. I wasn't satisfied with MS Access security and I decided to use MS SQL Express. I upsized database and everything works well... I have to deploy this application on users PC with setup. Anyway application had made by VS 2003, c# if is importan...more >>

Hi What is the maximum number of users supported on sql server 2005 express? Thanks Regards ...more >>

Hi Is there a way to synchronise/replicate an access db with sql server 2000 db, short of writing the code oneself? Thanks Regards ...more >>

Hi, I have one Table which has Sales for 5 Year, the structure is as follows Store ID INT Year INT Month INT SALES MONEY Is it possible to get the sales for Feb 2004 & Feb 2005 in a single query ? Something like this Store ID Year Month Sales 1 ...more >>

Hi We have an internal ms access database which we need to synchronise with our website with sql server 2005 backend which is hosted on a public host. My question is; is there a way to keep the two databases synchronised using the technologies built in sql server 2005 and/or access? We also...more >>

Hi, I am trying to run isql with some script on its input, and I am getting something like 1>2>3> at the beginning of the output. I suspect these are isql prompts, but I don't need them in my output. How should I suppress their printing ? I could not find an obvious way. ...more >>

Hai, In a table, I am having a field of data type SmallInt, whose limit is -32,768 to 32,767. How can I modify this data type to UnsignedSmallInt, with limit, 0 to 65535, is it possible? Or should I use only Integer? Thanks in advance. Regards, Uma ...more >>

I am installing SQL Server 2005 (Developer Edition) to use with Visual Studio 2005. I am installing it on my development machine, which is not part of a domain, and I am going to use it strictly for development, not in production. Here is my question: What is the best way to set up the serv...more >>

Got myself into a box!! Did my development work in sql 2005 -- neat works great Gotta put it into a sql 2000 instance for deployment. --- sql 2005 -- Database Properties -- Compatibility level set to SQL Server 2000 (80) detached the database copied the files into the data directory for SQL...more >>

This is an SQL statement that we had working in an Access database: Select First(tblProducts.ProductName) AS TheProduct, First(TheDescription) AS TheDescriptionText, tblProducts.ProductID, First(tblVersions.TheMedium) AS TheMedium, First(tblProducts.TheOrder) AS TheOrder FROM tblProducts LEFT...more >>

I have a SQL Server 2000 server running on a leased server. As they installed the server, I don't have access to the installation CD. Is there a way to download the utilities, such as Query Analyzer and Enterprise Manager so I can run these from other servers not running SQL Server? Thank Y...more >>

I'm writing a stored proc in SQL 2005 Management studio. My syntax checks out. I select the stored proc and in the popup menu I select Execute stored procedure. In the dialog I see the parameters needed and pass it a parameter then click OK. The stored procedure starts but returns an error mes...more >>

Is there a way to enforce Z or N cardinality through SQL Server ? TIA Howard ...more >>

Hi, I've inherited a SQL Server and one of the changes I made was put all the user databases in full recovery mode. Current backups are set for a full database backup at midnight every night and a log backup shortly thereafter. My question is: - I was told that the system databases shoul...more >>

I have an INSERT INTO statement that I am trying to modify. I am trying to insert today's date into the table. How can I insert today's date into the table using a SQL Statement. Here is a copy of what I have so far. INSERT INTO cfj_jobs_added_log (Job_ID, Job_Description) SELECT Job_ID,...more >>

Is it possible to see the line numbers of the T_SQL code in query editor, it would be usefull when writing code and you get a really explicit message like syntax error near ' at line 49 <GGGG> Thanks for any help, Bob ...more >>

Our MRP is running on Progress. We connect to it using the Merant driver. We run scheduled DTS overnight, but I need a particular sql table to be synced with the Progress table. I will only read the SQL table. I'm not sure where I should start. Any pointers would be appreciated. Thanks TD ...more >>

I have a nvarchar column that was imported from a fox pro table and I want to continue to use it as my primary key but, it has leading zeros. eg. ('0000000027') How can I convert this string to a data type that I can utilize identity(auto incrementing) in order to continue using this column...more >>

Create Procedure <MyProcedure> as Declare @MyNewKey as integer INSERT INTO MyTable (Myfield) Select Myfield from MyOtherTable where myOtherPrimaryKey = 1 --Can only return one record from select so I can only insert 1 record into my table which is fine. Question is, ...more >>

CREATE PROCEDURE <sp_MYstoredproc> @Myvar1 int, -- this one I will need to pass from the calling code @MyVar2 OUTPUT -- This one I do not wish to call from the calling procedure or sub, nor do I wish to receive it back in the calling procedure , I just want to use it i...more >>

Hi I have a typical vs2005/sqlexpress2005/sqlserver2005 setup. I am using the following connection string; <add name="Membership" connectionString="Data Source=.\SQLEXPRESS;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|aspnetdb.mdf"/> with sqlexpress 2005...more >>

Sometimes when I enter new data in a table row in the Management studio. I get an exclamation mark after I entered the data on a row and moved to the next row. The message I get when I hover over the exclamation mark icon at the left of the row says that the row was committed to the database b...more >>

Can I install Sql 2000 and Sql 2005 on same box? Any website with instructions? Evan ...more >>

I'm trying to return the average of an integer field for a group of records in my database. I'd like the average to include the integer and the remainder as one rounded decimal point; e.g., 7.299999 = 7.3. So far, all I've been able to return is an integer. I've reduced my testing to just us...more >>

in the SQL Books Online, i read this: ++++++++++++++++++++++++++++++++++++++++++++ How to create a logical disk backup device (Enterprise Manager) To create a logical disk backup device Expand a server group, and then expand a server. Expand Management, right-click Backup, and then click N...more >>

Can someone please explain why you get error 4425 when joining an already joined table to another table ? /* This query works as expected */ SELECT t1.somedata, (SELECT somedata FROM table3 t3 WHERE t3.key_ref = t2.key_ref) FROM table1 t1, table2 t2 WH...more >>

I am having a problem with a query statement when I try to use sum( ) on a field in the query. For example: select somast.fsono, somast.forderdate, somast.fcompany, sorels.fduedate, sum(fnetprice) from somast inner join sorels on somast.fsono=sorels.fsono where somast.fstatus<>'CANCELLED' ...more >>

Hi, I'm trying to copy data from db1.table1 to db2.table1 in 2k5, but can't seem to find a tool that does that. What can i use to do it? dh ...more >>

I'm just a test user (MSDN license), not a customer. ...more >>

i have some changes to make in user's database for this i have scripts with "alter view/alter proc ...." how i can make those changes without opening each script, but by taking all of them in some automatic way? sam ...more >>

Hi I am new to SQL Server Express and have done my first steps with a local test database together with Visual Basic 2005 Express. Now I want to install te database file in a shared folder to give access to other users too. Now I have the error message, that the file is located on a UNC shar...more >>

Hi, I have the mdf and ldf files of a database I want to use on my server. In enterprise manager, I select “attach database” and chose the mdf file. I immediately get the error “The file you’ve specified is not a valid SQL server database file”. I don’t think these files are physi...more >>

From Windows authentication to Sql authentication How to set? Thank you....more >>

Hi, I have the mdf and ldf files of a database I want to use on my server. In enterprise manager, I select “attach database” and chose the mdf file. I immediately get the error “The file you’ve specified is not a valid SQL server database file”. I don’t think these files are physi...more >>

Hello all, I would like to ask you about compatibility, because I detached all databases before upgrade Beta to final version. After successfull upgrade I have been try to attach databases back and I get information about incompatibility :((( Is there any way how to get the databases wo...more >>

I have 2 Client tables (for reasons I won't get into), we'll call them tblClient1, tblClient2. I have a 3rd table (tbl3) that has a ClientID column (varchar) and each record may reference data from either table, never both. tblClient1, however, uses an integer as the ID field, and tblClient2...more >>

Hello: I cannot seem to connect to a SQL 2005 Express instance using SQL Server Management Studio. Is this not supported? Thanks, -V ...more >>

Hi there A couple of bright sparks decided to clean up some of our databases, and in the process permanently deleted about 300,000 records from a particular table. I've spent a month trying to identify the missing records from archives and previous backups, and I've finally made some progress...more >>

I'm just getting started with SQL Server, using SQL Server Express. One of he first issues I ran into was SQL Server being denied access when I tried to attach a database file. I looked up SQL Server in Control Panel > Administrative Tools > Services and saw that SQL Server was logged on as...more >>

Hi anyone, I'm new in SQL Server and I'm trying to write a query that stores binary data in a table. Binary data consists in an SHA 512-bit hash and I don't know how to store it. This is my SQL script: CREATE TABLE Permission ( username varchar(16) not null, pa...more >>