Hi all, I have these lines repeated many times, every 1 second, in the error log: Login failed for user 'user' Login failed for user 'sa' Login failed for user 'root' Login failed for user 'admin' Is someone trying to hack my SQL server (version is 2000)? How can I control a...more >>

I have a XML file. Its physical file path is "C:\Dursgal.xml". There is a posibility to get the xml file's rows to a table in SQL database. I use MSSQL 2000. The xml file's some nodes are: <Dursgal> <UNBMS_ID>1122=D0=91=D0=9E=D0=9C00003</UNBMS_ID> <IsDursgal>true</IsDursgal> <ID_Zeregle...more >>

I am working on a strategy for archiving some tables that are growing quite large. We are on SQL 2005 Standard version, so I am running some tests using Partitioned Views. I have my main table and created an archive table identical in structure. Records that are over a year old are moved t...more >>

Hello, I have a request to that requires me to return the number of business days between two dates (only counting days between mon and fri). Is there an easy way to do this in SQL? Thanks! Rick ...more >>

I have a simple query with two parameters and for some reason they are not allowing any results to be returned. SELECT * FROM POLINE WHERE (PO_NUMBER = @PONUMBER) AND (COMPANY = @COMPANY) If I use the following: SELECT * FROM POLINE WHERE (PO_NUMBER = 1111) ...more >>

How can I DENY DELETE PERMISSIONS FOR ALL OBJECTS ALL AT ONCE instead of doing each object one at a time for a particular role called STAFF?...more >>

I wanted to Load the data in to a flat file from a SQL Server table..I know the options like BCP, DTS...but i want to know is there any way that we can dump using TSQL programming...appreciate if any one can send me the code snippet for the above functionality.........more >>

Hello Everyone, I am looking to set a primary key on a temp table in SQL 2000. I am getting an error that the a constraint by that name already exists when two or more folks call the stored procedure that creates the temp table. Anyone know what I need to do to accomplish this? ALTER T...more >>

I'm inserting multiple records into a table with an identity column. Now I need to retrieve the new ids for the inserted records. I thought of getting the max id before the insert and afterward selecting all records where the id > @maxIdBeforeInsert. But that won't work if another insert occurs ...more >>

I had a request to create a table that contains rows that are inserted and deleted based on the Primary key of another table. This looks like an ideal case to use the relationship properties between tables and check the Cascading Update and Cascading Delete options. after setting this up I ...more >>

Hi all, I have two integer columns that I want to format as date like 02/02/2007 3:30:00 am First column is for date and the values are like 20070202 Second column is for time and the values are like 235900, 200000 any ideas how can I do this? I got the date with cast(cast(colum_date as var...more >>

This question is with regards to SQL Server Express. A user does not have administrator permissions and only has read/write access. However at some point it will be necessary to create another database. Is there a way to create a database with code even when the user does not have permissions...more >>

We're going from SS 2000 SP4 to 2005 by EOY. From what I have read and heard, AMD is the more safe way to go in the sense that it does not emulate 32 bit apps but rather actually has a 32 bit architecture. Is that correct? Is AMD a little safer way to go if you're migrating generally speaki...more >>

Hello, I am getting the error: 'dbo.Posts.PostId' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause. On code: SELECT PostId = bp.PostId, PostTitle, PostContent, PostUpdatedDate, PostIsPublished, PostCommentsAreAllowed, U...more >>

I have the following tabel select * from a id fnm fsrc tsrc 1 col1 abc t1 1 col2 xyz t1 2 col3 pqr t1 2 col4 abc t1 how do i generate the following sql based on the above table when I pass in id as 1? create view v1 (col1,col2) as select abc,xyz from ...more >>

I am running a program which continues to run for a long period of time. During this time everything on my computer slows down and eventually I have to re-boot. I think it relates to the fact that I use Select Into many times to create tables which are used throughout the program. I delete ...more >>

i'm working with an ERP system that logs all users into sql-server under one sql-server login ID. Can I get the person's domain login ID from a trigger? ...more >>

I have written several simple stored procedures that receive parameters. Any suggestions on a book and/or web site that will give examples on how to write stored procedures that are more complex. ...more >>

Hello, I have the following tables: [Blogs] > BlogId (PK), ... [Posts] > PostId (PK), BlogId (FK), Title, Content, ... [Labels] > LabelId (PK), LabelName [LabelsInPosts] > LabelId (PK), PostId(PK) I am selecting all posts from a Blog given the BlogId: SELECT * FROM dbo.Posts WHERE BlogId...more >>

If anyone knows c# with sql server, I need a last column named "Total" from a calculation of another column please. Here's the code I now have without the column name: string name1 = GridView2.SelectedDataKey.Value.ToString(); SqlCommand cmd1 = new SqlCommand(@"Select quantity, prod_name, pri...more >>

i am getting a stranger error. i dont know the reason. every morning i download the file (text file) into SQL Server and i get this error. when i click ok it works again here is the error [DBNETLIB][ConnectionRead(recv())] General network error. Check ur network documentation. File Manage...more >>

Why does this statement produce an error SELECT ABS(diff) FROM (SELECT CAST( '-123' as decimal(28,2)) as diff) but SELECT ABS(diff) FROM (SELECT CAST( '-123' as decimal(28,2)) as diff) A does not with A or any letter as. Enilmik ...more >>

Hello, I have a date filed like "12/30/1899 3:30:00 PM" in SQL server 2000. I would like to display it just "3:30 PM". i.e user doesn't need date to be displayed and the time "3:30:00 PM" needs to be converted to just "3:30 PM". Can some one help me with this? Thanks -L ...more >>

We are trying to make an audit trail for some selected fileds in a database now we have to store a history of the updated fields using triggers . the problem here how do we know the original value of a column already updated to store that with the new value in the update trigger of some table ...more >>

What is the best way in SQL Server 2005 to get a GUID that was created upon insert into a table? I have this code right now -- Create new GUID temp table DECLARE @NewID TABLE (AcquiredViaID uniqueidentifier) -- insert record, but specify output for inserted rows to go into the newid tab...more >>

Hi group, I have this one simple line that I'm executing against SQL 2005, and I can't figure out why on Earth this is causing a problem: --------------------------------------------------- SQL: ALTER TABLE [Employee] ALTER COLUMN [FirstName] SET DEFAULT '' Error: Incorrect syn...more >>

Hi all, I have the following table structure: PartyRoleGroup table - PartyRoleGroupId PartyRole table - PartyRoleGroupId (f key to PartyRoleGroup) - PartyId - PartyRole Party table - PartyId - Name The PartyRole table will contain 2 or 3 records for each ...more >>