Hi! I'm having doubts about WITH TIES command I have this query: USE pubs SELECT TOP 10 sales.qty, sales.title_id, stores.stor_name FROM sales JOIN stores ON sales.stor_id = stores.stor_id ORDER BY sales.title_id DESC This is plain simple...it gives me 10 rows. Everuthing fine. ...more >>

I have a table that contains a smalldatetime field. One of the records had a date entered into this field, and now I need to remove the date from the field. Whenever I try to just "delete" it (delete key) I get a message: The value you entered is not consistent with the data type or length of...more >>

I am trying to do an update where I first cast as string as a INT and get back the following message: Server: Msg 245, Level 16, State 1, Line 1 Syntax error converting the nvarchar value '725 ' to a column of data type int. When I past the offending column contents into Word it shows two ...more >>

I am taking over a DBA position where the previous DBA left the firm and I do not know the structure and/or the tables, views etc. What is the best way ( and the fastest)for me to find this out? thanks in advance...more >>

Hi can i please have some assistance around performing a sql query that inserts data based on a date range. for example my initial query is INSERT INTO tbl_master ([date], unavailableemployeeid, reasonid, unavailablehours) VALUES (, 1234, 12, 7) but i want to ...more >>

We're a small non-profit org. (NPO) running Small Business Server 2003 (SBS2K3) and will finally (!) get broadband in the very near future. I want to re-do our website with a ePhilanthropy focus. To do that, I'll need forms for users to log in, enter and have the site save their info, let ...more >>

Hi, I have a shared SQL database which drives a web site that I have created. This is hosted on a particular domain. I am transferring the site, and I want to move the SQL database data into a new SQL database on our new server. What is the best way to do this? I have, in the past, saved...more >>

A problem occurred while attempting to logon as the Windows user 'SQLAgentCmdExec': The parameter is incorrect. The step failed. There are a few jobs that developers create and they run under there accounts, I do not want to give them sysadmin access, but they need permissions to CmdExec. I e...more >>

Is there a way to drop all constraints on a table without knowing it's name? A constraint was created with a '-', and when attempting to drop it: ALTER TABLE [dbo].[tblClients] DROP CONSTRAINT [FK_tblClients-Address] GO I get an error saying Incorrect syntax near '-'. Second problem: when...more >>

Bonjour à tous, Quelqu'un peut-il m'aider sur le problème suivant ? j'ai bien chercher sur le net mais n'ai pas trouvé de réponses... <CONTEXTE> ------------ Je doit importer une base cliente sur ma plateforme de dev Ma plateforme est sous Windows 2003 et se trouve dans le groupe de tra...more >>

Could you briefly explain how to set up ODBC to create links so I can easily transfer my MS Access Tables and related forms, roports, and queries to SQL Server or point me to a good article or web site? I am just starting to learn SQL Server and need to import my existing tables, forms, rep...more >>

A problem occurred while attempting to logon as the Windows user 'SQLAgentCmdExec': The parameter is incorrect. The step failed. There are a few jobs that developers create and they run under there accounts, I do not want to give them sysadmin access, but they need permissions to CmdExec. ...more >>

I need to compare records in several Access tables with records in corresponding SQL Server 2000 tables by primary key value. Is is it possible to join an Access (Jet not MSDE) table with a SQL Server table? If not, what is the eaiest way to import an Access database into a SQL Server database...more >>

Hi everyone I was wondering if is there a way that I can get how many times users have been connected to my database in sql server 2000 group by on NT user, also I want to make a stored procedure that stores every week or month how many times users connected to sql server, to monitoring the...more >>

Hello Group Can someone provide me with steps of troubleshooting a slow SQL 2000 Database Immediate response would be appreciated Davis...more >>

I have Visual Studio .NET and SQL Server Desktop Engine on my computer. I have created an empty database using Visual Studio .NET's Server Explorer. However, I am having trouble connecting to the database using ASP.NET. I think the problem is somewhere in my connection string, but because I do no...more >>

I have an sql to select 'customers', something like Select * from clients inner join cases on clients.id = cases.clientid The client may have multiple cases and if I run the query like that I may get the same client multiple times, how can I only display the client once when there are multi...more >>

I have an sql to select 'customers', something like Select * from clients inner join cases on clients.id = cases.clientid The client may have multiple cases and if I run the query like that I may get the same client multiple times, how can I only display the client once when there are mul...more >>

what is the chinese microsoft newsgroups NNTP name ? pengfei thanks. pengfei ...more >>

I just finished running rebuildm.exe to change the collation name. All seemed to go OK, and I re_attached the databases associated with my main application. After doing so, when I try to start the app, I get the following error: Login failed for user 'sa' Then I get Focus<<server_login...more >>

I want to create an empty SQL Server database with nothing in it so that I can add tablesand other stuff to it using sql code. How do I do this? -- Nathan Sokalski njsokalski@hotmail.com http://www.nathansokalski.com/ ...more >>