Programming SQL

Login failed for user 'x', Error: 18456
hi I've installed sql server 2005 express on my winxp machine (sp3). And created a login and restored a database and created a database user based on that login. When I from my asp.net app tryes to connect I get a Login failed for user 'x' error. Also I get this error when login into the sql servre manageme... 12 Mar 2010 06:08

Collation Problem in a Union Query
Hi, I have two queries that I'm using UNION on. The queries run fine individually but when I use UNION, it gives me an error complaining about collation. In the first query, I had to use COLLATE SQL_Latin1_CP1_I_AS on one of the columns. Thanks for your help. ... 24 Feb 2010 15:26

Using xp_fixeddrives on a linked server
Thanks Anit..this helped me a lot. From http://www.developmentnow.com/g/113_2005_5_0_0_526805/Using-xp-fixeddrives-on-a-linked-server.htm Posted via DevelopmentNow.com Groups http://www.developmentnow.com/g/ ... 24 Feb 2010 07:32

Blocking problem
Hi there, I'm invoking "SqlConnection.BeginTransaction()" just before I do a series of inserts into multiple tables. I just ran a test and discovered that until the transaction is committed, it apparently blocks other users coming through the same code. Each user will be inserting completely different data i... 27 Feb 2010 14:22

Count Deleted from Output Trick?
Using SQL Server 2005, I would like to do a delete statement and simply capture the number of rows affected by the delete to an int so I can write that message to a global temp table. Something like the below, but actually working. :) -- ##globaltemp already exists declare @counttable ( curr int ) ... 24 Feb 2010 04:16

How to select day_of_week and/or date given a period?
Hi, I have a table with the following columns: Date smalldatetime DayOfWeek int [...] Both, Date and DayOfWeek can be NULL but only one of them can be non-NULL. DayOfWeek, if not NULL, can have a value 0 - 6 (0 = Sunday). When given a period (i.e. date range) I need to select rows that satisfy the follow... 24 Feb 2010 13:10

Check Contraint in Stored procedure
We have Check Contraint when defining fields in a table to validate or limit data value during input. I am wondering if there is a similar thing in Stored Procedure validating input parameters that should only have specific input values without writing the checking code inside of sp. OD -- Message posted vi... 23 Feb 2010 14:45

Complex Statement - Newbie Needs Help
Using SQL 2005 Have a table that we'll call types. Type A thru E. In a second table we have data that includes types, date_of, and cust_ID. I need to show totals for types A thru E for each month even if the totals are zero or null. I can't seem to get be able to show this. Types Jun Jul Aug Sep Oct Nov Dec A... 23 Feb 2010 18:15

How to increment a column with varchar data type
please sens answer to me From http://www.developmentnow.com/g/113_2006_4_0_0_737400/How-to-increment-a-column-with-varchar-data-type.htm Posted via DevelopmentNow.com Groups http://www.developmentnow.com/g/ ... 23 Feb 2010 15:53

SQLServer equivalent of Flashback
Hello, Oracle has a feature of 'flashback' for a tablespace. This means reverting back to a snapshot taken on a earlier date. Is there any equivalent feature in SQLServer? just curious.... tia, AbbA ... 23 Feb 2010 03:35