|
|
|
January 2003 June 2003 July 2003 August 2003 September 2003 October 2003 November 2003 December 2003 January 2004 February 2004 March 2004 April 2004 May 2004 June 2004 July 2004 August 2004 September 2004 October 2004 November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 |
Filter by week: 1 2 3 4 5 Security issues in SQL Server 2005 Posted by Bergs at 12/14/2006 7:39:05 AM I cannot block user access to tables. I have restriced accounts at the
server, database, group, schema, and table lavel and can still open
tables right up.
In other words, I have absolutely no security. Any ideas?
...more >>
Help with joining records Posted by Rnt6872 at 12/14/2006 6:02:00 AM Table A Table B
BOL# B_BOL#
Chargeback#
Hi All,
I have been struggling with this for the past few months. I have two
tables that I'm inner joining on BOL#=B_BOL#. This works fine. Now...more >>
Opinion about design needed (splitting string data) Posted by Matik at 12/14/2006 5:46:30 AM Hi to everyone,
My problem is, that I'm not so quite sure, which way should I go.
The user is inputing by second part application a long string (let's
say 128 characters), which are separated by semiclon.
Example:
A20;BU;AC40;MA50;E;E;IC;GREEN
Now: each from this position, is already d...more >>
Inner Join Problem Posted by info NO[at]SPAM bodykind.com at 12/14/2006 1:56:23 AM The following query works fine in access and does exactly what I want
it to do however I get a syntax error when I port it over to SQL Server
2000.
-------------
UPDATE OrdersProducts INNER JOIN Products ON OrdersProducts.ProductID =
Products.ProductID SET Products.Stock =
Products.Stock-O...more >>
SQL can it be done ? Posted by JF Fortier at 12/13/2006 6:05:30 PM Hi group
I'm not familiar with the name, newbies user.
The SQL key is call Row # ?? if that correct can it be possible to create a
new record and replace that unique ID key to a previous erase value ??
Some one did a terrible mistach by erasing data without knowing the full
consequence ...more >>
getting length of 8 characters Posted by TGEAR at 12/13/2006 12:55:20 PM Claim number (string)
CF060001
CF060001A
CF060001B
AV000001
AV000212F
AV000001F
FD232122
FD232122G
SD223213
SD223213H
I only want to get records, which have length of 8 characters.
So output will be CF060001, AV000001, FD232122, and SD223213
Anyone can help me to write this in sql?
...more >>
How do I find out how full my files are? Posted by caseahr at 12/13/2006 9:55:25 AM When you create data files and filegroups, you specify a size. My
question is -- how do you know how full they are? Is there a stored
procedure for that?
...more >>
How to match records on several substring functions Posted by Rnt6872 at 12/13/2006 9:47:01 AM Hello All,
I have a sql statement that I'm using to match records on. But i need
to use a substring to get the nuber that I need, and I have to use
several substrings to get the number since its embedded in other text.
Here's my sql:
use fto_ups
select distinct o.Shipper#, o.InvoiceDate, o.Inv...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Backup Priority level Posted by gabe101 at 12/13/2006 9:12:18 AM I've searched enough to know that this ability probably doesn't exist
in our current setup, thus the reason I'm coming to the community now.
When doing a database backup in Enterprise Manager (SQL Server 2000
sp4), is there a priority level setting so that I can put less load on
the CPU? Our sm...more >>
Query help please Posted by roberthornsby NO[at]SPAM hotmail.com at 12/13/2006 5:09:34 AM Hi,
Please can you help me with this query which I am struggling with?
Here is a simplified version of the table I am trying to work with
VehicleId, PurchaseId, PurchaseDate, Comment
1, 1, 03/03/2006, 'customer has a big nose'
1, 79, 04/04/2006, 'it's raining'
1, 8, 05/05/2006, 'ma...more >>
Missing the zero (0) Posted by Marko at 12/13/2006 4:28:11 AM Hello all,
I hope someone can help me; if got a value in a cell (040 1234567),
when I run a query
in the Analyser I got as respons only 40 1234567, so missing the zero
(0) not the whole number is displayed. When I run a query on a cell
with value 1234567 I received the number 1234567 and tha...more >>
please, how to realize generalization in sql server database Posted by fireball at 12/12/2006 6:02:34 PM please help, I need professional approach how to realize generalization
(parent_table <- child_table) idea in sql server databse?
in my Oracle db I can have PK of child_table as FK from parent_table: let's
have shop with shoes, selling shoes, and foosd as well. Example of keys in
my tables:...more >>
Can't connect to SQL server Northwind database Posted by podx at 12/12/2006 3:12:25 PM I am trying to connect to SQL 7.0 northwind database via visual studio
2005. But I can't open the connection. I get an error saying remote
access is not allowed. But the remote access is ok. I can used the same
login and connect to the sql server via enterprise manage.
SqlConnection conn = new...more >>
Problem after Restore Posted by smoscar NO[at]SPAM gmail.com at 12/12/2006 3:09:49 PM I received a few cd's from a client, with a .bak MS-SQL database
backup, installs for tomcat, and java. Everything was provided via an
altered webapps folder tomcat, which holds an almost all JSP setup.
I figured out the login issue I was having, was able to correct, and
properly view the tab...more >>
SQL2005 Default accounts Posted by Laurence Breeze at 12/12/2006 2:38:38 PM I've just been looking at a new 2005 install and found 3 logins:
SERV1\SQLServer2005SQLAgentUser$SERV1$MSSQLSERVER
SERV1\SQLServer2005MSSQLUser$SERV1$MSSQLSERVER
SERV1\SQLServer2005MSFTEUser$SERV1$MSSQLSERVER
Are these logins created during the install of SQLServer2005 by default
and what ...more >>
Converting a varchar to int Posted by Patti at 12/12/2006 7:04:06 AM I am struggling with converting a certain varchar column into an int.
I have a table that has 2 fields - one field holds the loan number and
the other field holds the codes associated with that loan number.
Here's some example data:
Loan# Codes
11111 24-13-...more >>
odbc-timeout error on a linked table from Access2k Posted by olle NO[at]SPAM ylm.se at 12/12/2006 5:57:30 AM Hi.
I have the problem that some records in a ms sqlserver table is unable
to update from Access.
I get the error message odbc-time out error in linked table......
I tried to copy this table to another database, where none but me was
aktive.
And then it worked quit ok when I try to save th...more >>
asdb - what is it? Shold I back it up? Posted by mfine NO[at]SPAM array.ca at 12/11/2006 6:47:42 AM We developed a DB for our customer using MS Access and upsized it to
SQL Server. Our customer does daily back up of his DB and he asked me
whether or not 'asdb' should be backed up as well.
My question is: what is 'asdb' and whether or not it should be
backed up. Any information or web links w...more >>
Need to convert cursor Posted by Patti at 12/11/2006 6:32:12 AM I am new to SQL and have created a stored procedure for a .net web
application. Unfortunately I had to use a cursor in the stored
procedure, so it is taking several minutes to execute because it has to
read through about 15,000 records. There must be another way to do
what I'm trying to do wit...more >>
Urgent....please respond Posted by frien at 12/10/2006 7:43:31 PM I want to create a stored procedure to find if the index exists if not
i have to create the index....i use following stored procedure....but
does'nt seem to be working.......but when i hard code the query it does
work... can u plz tell me were i am going wrong
CREATE PROCEDURE [dbo].[sd_find_c...more >>
Northwind - execution plan bug? Why Index Seek and no Bookmark Lookup? Posted by serge at 12/10/2006 12:59:33 AM If you display the execution plan and run the following:
SET STATISTICS IO ON
go
SELECT ProductID, SupplierID
FROM Products
WHERE SupplierID = 1
I don't understand how come there is no
Bookmark Lookup operation happening to get the
ProductID?
I only see an Index Seek happening on ...more >>
memory 64bit windows , 32 bit Sql Posted by mike at 12/8/2006 8:17:14 PM I have found that orig tested 64 bit on our 64bit windows 2003
server...about 1 year ago...and company decided to use sql 32 bit on the
64bit os
my question and any information is very welcome
is there any things in need to know about awe with
memory above 4g ...whilst using 32 bit sql on...more >>
set default precision on decimal type? Posted by Boot2TheHead at 12/8/2006 9:34:18 AM This one cost me a solid half hour yesterday. I'm wondering why on
earth the default precision for a decimal type is 18,0. Maybe I'm
mistaken. A decimal datatype sort of implies that you'd want something
after the decimal!
Question is, can I set this database-wide? Like all new decimal
dataty...more >>
Searching for Last DateTime Posted by patelk23 NO[at]SPAM gmail.com at 12/8/2006 1:53:41 AM Hi everyone,
I am really struggling to do the following in sql. Your expertise will
be very welcome.
I have a table [TestData] below
IndexId IndexVersion LastAmendedWhen
---------- --------------- -------------------
29 1 06/10/2006 17:40:43
29 ...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |