I am looking for a pre-packaged solution for auditing record level changes to SQL tables. I know this can be set up through custom triggers but my organization does not have the resources to develop this. We are looking to buy something that will work out of box. Does anyone have any recomm...more >>

Hello there: I have a question I hope somebody can help me. In a SQL db I must store in row PDF files which can grow without any basis. I know due to bibliography that you are allowed to store up till 2GB binary data. Due to that fact there will not be any problem, because the PDF files ...more >>

How does one get the name of a column that is the PK on a table. I can get as far as select * from sysobjects where xtype = 'PK' and parent_obj = ? but how do I link to a column name? TIA LH ...more >>

I am new to SQL server but I need to figure out how to monitor the contents of a folder then move files from this folder to another folder when a new file shows up. I do have experience with VB script and VB.Net and have created both a script and an exe that do what I need. The trouble is that...more >>

Hi I have a simple Insert Query that I used while the DB was in Access, I've migrated the data in the SQL server and I get an error message saying that Access can't Append because there is a Key Violation, the only key is the ID which I'm not append onto as it's Autonumber is Access. Thanks...more >>

Hei! I am getting this SQL error when i tried to use SQL Query Analyzer, Unable to connect to server AxpServer1 Server: Msg 18456, level 16, state 1 Microsoft ODBC SQL Server Driver SQL Server Login failed for user 'sa' On the EM SQL Server Properties (Configure) on the Security tab Authent...more >>

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 >>

Hi, I got a request to setup so that Reporting Services can connect to an Oracle database. When they select a data source, I see ODBC but I also see an option that's called Oracle. What do I need to setup/install on my SQL Server so the developers can create a report that connects to an O...more >>

strSQL = "SELECT SA, ProblemType, Count(ProblemType) as ProbType FROM Problems WHERE RptDate >= " & sIn(bDate) & " AND RptDate <= " & sIn(eDate) & " GROUP BY SA, ProblemType ORDER BY SA" Results Look like this - no space in between different SAs. Steve Monitor 1 Steve Printer 1 ...more >>

Are there any tools that allow you to compare two sql server databases to find out what is different between them (the database structure, including tables, relationships etc)? Thanks, - Gabe ...more >>

Can anyone tell me why this stored proc is not updating the REMAINING field when it runs the first time? ALTER PROCEDURE SP_CHANGECAPACITY @COCODE INTEGER AS DECLARE @SECTION CHAR(10) /**/ DECLARE @DATEE SMALLDATETIME /**/ DECLARE @OPR INTEGER /**/ DECLARE @EFF FLOAT /**/ DECLARE TEM...more >>

I have 2 servers in my company which is server A and server B. Server A will end of life at the end of this year and I wish migrate the whole database to Server B. I wish to know how to migrate Login setting to Server B the Login is in Microsoft SQL Servers > SQL Server Group > Server B > ...more >>

Hi, Is there any separate news group for SQL Server 2005? ...more >>

Hi every body, I have recently find out we can train ourself on SQL Server thanks to the Express Edition. So I'm trying to import a db structure (.sql file) and then fill it with some data given in another file (.txt) But I can't find any relevant documentation (a reference guide for ex...more >>

Hi how can I print queries in color mode ...more >>

I have been trying to track down a database problem in which for some reason when somebody enters in some data into the database it becauses unavailable for the application. I looked under Locks/Proccess ID and found that one of the proccess is 'blocking' can somebody elaborate as to what sor...more >>

I have created a small batch file that runs a DOS command to copy a file. When I run it from the DOS prompt, it works fine. When I try to run it as a scheduled job, it fails (even though it is reported as successful). When I run it from DTS, it works. Can anyone shed some light on what may ...more >>

I have access to the Server (Win2003 SBS) through Remote Desktop Connection. I need to change the Permissions of a DataBase Role in the msde instance on that server. I can't seem to find a way to connect to that instance. Is it even possible through a Remote Desktop Connection? Thanks for ...more >>

How do I query one table In database A from Database B on the same server. ...more >>

How would I go about linking a table in one database to anouther database on the same server? I need to qry related data from one table to anouther table in different databases. I know that I can import the data, but I was hoping that there is a better way....more >>

hi everone i have question about DBCC SHOWCONTIG results of Table we have table with huge amount of data in it. When i run ''dbcc showcontig('<TableName>') with fast, ALL_INDEXES,TABLERESULTS '' i saw that most of indexes have logical fragmentation over 80% then i run DBCC dbreindex and...more >>

Is there anyway that I can view the status of a transaction? To see if the data even reached the database. Apparently some data that users are inputing into this application, lets say they input 5 rows, sometimes they don't show up in the database, so I am trying to find out if it even made it...more >>

If a given text field is always 3 characters or less, is there a reason why varchar(3) is better/more efficient etc., than varchar(4). Or does it really make any difference? I was told when designing the table it really doesn't matter. Is this true? If varchar(3) is the same as varchar(10), wh...more >>

Is their a way to query database metadata to find the last tabe / view updated? Gary ...more >>

I want to store documents in SQL Server (using it as a file repository) so it can be accessed via a WebForm in .NET. Is this possible and if so is there any references or documentation about to do this? BTW - The .NET stuff I can handle. Thanks. ...more >>

On my ASP page, with a SQL backend, I have the following code to insert a date value into a table, but it is not working correctly. sql = "UPDATE Problems SET FupDate = '" & updFuDate & "' WHERE TicketNumber = " & tn & "" The value updFuDate is currently 06/15/2005. The command works, howev...more >>

Is there a better way to search for duplicate records. Currently Im accomplishing this by using two views. Veiw1 looks like this SELECT BoxId, COUNT(BoxId) AS Expr1 FROM dbo.tblInvCount GROUP BY BoxId HAVING (COUNT(BoxId) > 1) View2 looks like this SELECT ...more >>

Hi, I need to move a database from SQL2000 to MSDE. I've googled for it and figured out I should use DTS to do so, however I can't seem to find the procedure on the MSDE side to "restore" the data base. any help would be kindly appriciated :)...more >>

Is there a way to limit a column to a set of years, including the current year, whatever that may be? for instance, a column can only contain years 1950 to currentyear, without me having to change the currentyear every year? Would I do this through a rule/user defined type? If So, can you...more >>

Hi, What is the best practice for virus checking and backup of a W2003 server hosting SQL2000? Virus checker is CA eTrust, backup is Veritas 9.1 (without the SQL agent) I occasionally have problems with a SQL app "hanging" for a couple of minutes which I think could be due to realtime v...more >>