Psst! Did you know DevelopmentNow is a mobile web site design agency?

Contact us for help mobilizing your site, or to sign up for our beta Mobile Web SDK!


Archived Months
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
all groups > sql server (alternate) > december 2005

Filter by week: 1 2 3 4 5

Granting dbo ASSEMBLY EXTERNAL_ACCESS permissions
Posted by coosa at 12/30/2005 10:28:01 AM
Hi all, I have tried to create an asembly with PERMISSION_SET = EXTERNAL_ACCESS under SQL Server 2005 but i failed so far. I also see the TRUSTWORTHY Property for the database as disabled and can't enable it. I know that the sysadmin has the full authority for all activities, but i'm logged ...more >>


No ending Rebuild master
Posted by hazly at 12/30/2005 1:42:20 AM
I'm using SQL SERVER 2000 and in the process of establishing recovery guide. Tried to rebuild master using rebuildm.exe but the "Configuring Server" never ending. Then I tried to copy original databases from SQLServer Installation CD to hard disk as the "Browse for folder", but gave the same pr...more >>

XML Data Processing
Posted by _(d)IEGO at 12/29/2005 11:21:26 PM
Hello everyone. I need help regarding the following: Given the following table: CREATE TABLE T1 (C1 nvarchar(10), C2 money) INSERT INTO T1 VALUES ('A',1) INSERT INTO T1 VALUES ('B',2) INSERT INTO T1 VALUES ('C',3) let's say that i have this table in a local server and i want to upload i...more >>

Simple SQl question
Posted by Erich93063 at 12/29/2005 12:12:26 PM
I am trying to create a SQL statement that returns values from fields in the database but I also need to return values that are NOT in the database but hard coded int he SQL statement. The values along with the names of the fields will be hardcoded into the SQL statement. I'm not sure if this ca...more >>

How to know the User who disabled a Job??
Posted by sasi at 12/29/2005 7:07:40 AM
Hi all, Is there any way I can know who Disabled a Job?? bye. ...more >>

XML data feed
Posted by billy at 12/29/2005 5:08:50 AM
Hello, I have an XML data feed that I would like to use to create tables in SQL Server. The xml data feed consists of a large amount of information that changes on a regualar basis. Is there a way to automatically create SQL Server tables using the data feed? Thanks Billy ...more >>

!TAKE ADVANTAGE OF A PAYPAL FLAW! MAKE THOUSANDS LEGALLY! - "!TAKE ADVANTAGE OF A PAYPAL FLAW! MAKE THOUSANDS LEGALLY!.txt" 5312 Bytes yEnc
Posted by ChoujaTD at 12/28/2005 9:39:53 PM
Follow the directions below and in two weeks you'll have up to $20000.00 in your PayPal account. There is a very high rate of participation in the program because of its low investment and high rate of return. Just $5.00 to one person! THAT'S ALL !!! If you are a skeptic and don't think the...more >>

Deadlock on Update using temp table
Posted by fmatamoros NO[at]SPAM yahoo.com at 12/28/2005 6:29:30 PM
I sometimes get the following error from an update statement in a stored procedure: Transaction (Process ID 62) was deadlocked on thread | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction. The isolation level is READ UNCOM...more >>



(Can't get) Media for SQL Server 2005
Posted by Larry Bertolini at 12/28/2005 3:24:01 PM
We have a software assurance contract, and we get our media from a Microsoft Certified Partner. Our MCP hasn't been able to provide us with media for SQL Server 2005. It's been 7 weeks since the launch; I expected the product to be in the channel by now. Anybody else (especially software a...more >>

Microsoft Distributed Blank CDs for Sqlserver 2005 and MSDN Library at Launch??
Posted by D Kav at 12/28/2005 12:23:31 PM
The SQL SERver 2005 Standard Edidtion install CD and the MSDN CD distributed at the SQLServer Launch in Chicago are blank. Has anyone else had this problem and or requested replacements? If so, how. thanks much Mo ...more >>

Index for username/password
Posted by Cecil at 12/28/2005 5:20:58 AM
Does this make sense for a logon table: CREATE TABLE Logon ( ID INT NOT NULL IDENTITY PRIMARY KEY, name VARCHAR(15) NOT NULL, password VARCHAR(15) NOT NULL ) GO CREATE UNIQUE INDEX IX_Logon_Name ON Logon(name) CREATE INDEX IX_Logon_NameAndPassword ON Logon(name,password) GO ...more >>

Moving SQL Server to a new drive
Posted by Todd Beauchemin at 12/28/2005 3:24:15 AM
We installed MS SQL Server to our drive D drive E was the CDROM Drive. We wanted to move the CDROM drive to drive D and the hard drive to drive E. We change that around and corrected the registry entries - repointing everything to drive E instead of D. SQL Server however will not start it says...more >>

dateformat is ignored
Posted by newtophp2000 NO[at]SPAM yahoo.com at 12/28/2005 1:59:47 AM
Hello, I receive a file containing some character fields along with a date. The date values in the file are formatted as "dd/mm/yy", that is 2-digit day, 2-digit month, and 2-digit year. The separator could be slash or a dash ("-"). The file is in a proprietary format, and bcp is not an opt...more >>

Backup failed: Operating system error 112(error not found).
Posted by smeagol at 12/27/2005 11:55:08 PM
Hi, I keep getting this error message for a trans.log backup. Operating system error 112(error not found). The disk has about 6GB space free, and the backup should only take up about 550 MB, so I would think it is not space related but... The disk is ...more >>

Need help with a join
Posted by Danielle at 12/27/2005 3:46:33 PM
Hello group- I am having a problem where joined tables are returning too many rows. Here is my scenario - I am trying to create a temporary table from parts of three tables - the important columns are: a.id a.tran_date b.id b.geo c.holiday_date c.geo My query is like this sel...more >>

Is "name" a keyword?
Posted by Cecil at 12/27/2005 12:32:13 PM
It's blue in SQL Studio but I can't find it in SQL Books on-line. I wanted to use it as a field name but don't like using []. Is it reserved? ...more >>

Oracle/MS SQL Interface
Posted by brogdonm at 12/27/2005 12:22:33 PM
Hi everyone. I need to be able to query a database in Oracle and then actually save the data in an MS SQL database, does anyone know what is the best way to do this? Would it be best to do everything internal (inside MS SQL) or external (with some script: javascript, vbscript, perl)? Thanks ...more >>

How many CALs for a web page?
Posted by wackyphill NO[at]SPAM yahoo.com at 12/27/2005 7:31:13 AM
Is there any way to know aprox. how many cals a DB should have for an avg website. I don't really know how many concurrent users there will be. ...more >>

view with auto_increment field
Posted by cmm at 12/27/2005 5:46:31 AM
I am trying to create a view in MSSQL that has a column which is an auto increment (or unique id) field but it doesn't work the way I want it. Does anybody have an idea how to do this? The example below gives me only 0 in the id field. CREATE VIEW dbo.tree_x_categories AS SELECT @@ROWCOU...more >>

Createa table like a existing table?
Posted by SSG at 12/26/2005 10:27:22 PM
Hai all I am new to SLQ server. Can anyone tell me how to create a table that should look like a existing table fields.... thanx ...more >>

SQL Server 2000 Installation error
Posted by coosa at 12/25/2005 10:31:56 PM
Hi, I was installing SQL Server on my machine and during installation my PC freezed. It happens frequently on my machine. So i tried after restarting to install it again and since then i always get the same error message: "An error occurred while creating one or more registry entries. Please ...more >>

Synchronising/replicating access with sql server
Posted by John at 12/25/2005 3:09:24 PM
Hi Is there a way to synchronise/replicate an access db with sql server 2000 db, short of writing the code oneself? Thanks Regards ...more >>

Synchronising with remote server
Posted by John at 12/25/2005 1:09:05 AM
Hi We have an internal ms access database which we need to synchronise with our website with sql server 2005 backend which is hosted on a public host. My question is; is there a way to keep the two databases synchronised using the technologies built in sql server 2005 and/or access? We also ha...more >>

C++ and SQL Server programming
Posted by Brooke at 12/24/2005 8:33:52 PM
Are there any good resources (books, websites, etc) for programming SQL Server using Visual C++? I am currently using C# but I really want to learn how to do it using C++, but it appears to be much more difficult using C++. Thanks ...more >>

Temp Table Faster?
Posted by wackyphill NO[at]SPAM yahoo.com at 12/23/2005 12:06:08 PM
If you were doing paging of results on a web page and were interested in grabbing say records 10-20 of a result set. But also wanted to know the total # of records in the result set (so you could know the total # of pages in the set). Would it be better to query the DB table 2X. Once for Count...more >>

SQL Server Std vs Small Business Server 2003
Posted by WeLeh2 at 12/23/2005 11:30:04 AM
Anyone knows what the difference is between SQL Standard edition OLP and SQL Server in SBS 2003? I'm interested in purchasing SBS2003 because the price is much lower than if you buy OS2003 + SQL2003 separately. ...more >>

Stored Procedure only works in when app uses trusted security
Posted by ZRexRider at 12/23/2005 9:22:01 AM
Hi, I have a .NET application that connects to a SQL 2000 database using trusted security. It eventually calls a stored procedure that receives 3 parameters - nothing special. If I simply change the connection string to use a valid Userid and Password it still connects to the DB w/o probl...more >>

How to execute a "batch file" using SQL Server 2005?
Posted by coosa at 12/23/2005 5:54:12 AM
Hi all, As the topic describes, I'd like to run a batch file using sql server. How do i do it? Thanks in advance ...more >>

Stuck with sorting columns
Posted by wgerrard NO[at]SPAM gmail.com at 12/23/2005 3:56:34 AM
I have the following table (which is an import from another system I can't mod):- CREATE TABLE [tbl_wsg_maternity_observations] ( [documentname] [varchar] (40), [clientguid] [decimal](16, 0) , [docguid] [decimal](16, 0) , [displayname] [varchar] (80), [valuetext] [varchar] (255) , [...more >>

Export SPs?
Posted by laurenq uantrell at 12/22/2005 10:03:41 PM
I have uses DTS Import/Export wizard to export all my tables from one databse to another on the same server. How do I export all of my stored procedures and UDFs? Thanks, lq ...more >>

Export SPs?
Posted by laurenq uantrell at 12/22/2005 10:00:02 PM
I have uses DTS Import/Export wizard to export all my tables from one databse to another on the same server. How do I export all of my stored procedures and UDFs? Thanks, lq ...more >>

Referential Integrity
Posted by chavasreedhar at 12/22/2005 6:24:11 PM
Hi how to set the referential integrity between 2 tables using enterpris manager (microsoft SQL SERVER).. i tried and the tab doesn't allow m to choose. pls.help. thanks sre -- chavasreedha Message posted via http://www.exforsys.com for all your training needs ...more >>

intead of update/insert trigger on view question
Posted by V T at 12/22/2005 1:47:25 PM
Hello all, SQL Server 2000 documentation http://www.microsoft.com/technet/prodtechnol/sql/2000/reskit/part10/c3761.mspx states that if view is using "NOT NULL" columns of a base table, then insert/update performed on a view must provide dummy values for those columns, and code of the trigger...more >>

MS OLE DB for ODBC with Oracle ODBC source headaches
Posted by Crazy Cat at 12/22/2005 9:23:35 AM
Hi all, I am having trouble getting linked Oracle 9 server in MS SQL Server 2005 Express to work properly. My machine is running Windows XP. The Microsoft and Oracle OLE DB Providers have problems dealing with Oracle's Numeric Data Type, so I decided to use Microsoft's OLE DB for ODBC Provi...more >>

Index on two columns doesn't allow NULL in both - HELP!
Posted by teddysnips NO[at]SPAM hotmail.com at 12/22/2005 7:25:09 AM
Table DDL below: The tables I have contain Timesheet information. Each row in the tblTSCollected table contains an entry for an employee into the timesheet system, specifically by scanning the barcode on their badge. A whole bunch of business logic periodically attempts to "pair" these int...more >>

How to schedule a stored procedure
Posted by Ranjit at 12/21/2005 10:10:14 PM
I'm new to sql server programing. Please help me to scedule a stored procedure to run every hour. Thnak you all. ...more >>

Breaking apart Column into rows
Posted by rcamarda at 12/21/2005 2:05:43 PM
I have a column that has text delimited by a percent sign that I wish to turn into rows. Example: A column contains ROBERT%CAMARDA, I want to turn that into two rows, one row with ROBERT and antoher row with CAMARDA. I will have source rows that have zero, one, or many percent sign delimiters ...more >>

Making a view that shows the results of several different queries.
Posted by Ryan at 12/21/2005 1:51:38 PM
Hello, I am trying to create a view that shows the following Field1: Sum of Amounts from Table A Field2: Count of Amounts from Table A Field3: Sum of of Amounts from Table B Field4: Count of Amounts from Table B .. .. .. Field3: Sum of of Amounts from Table H Field4: Count of Amounts...more >>

Where the !@?!@ is my Stored Procedure?
Posted by Crazy Cat at 12/21/2005 1:42:51 PM
Hi, I wrote the following in the SQL Server 2005 Express Management Studio Query Analyzer and hit execute. Even though Query Analyzer indicated success when I hit refresh on the stored procedure folder the procedure does not show up in the stored procedure list. When I entered 'exec Test' I g...more >>

Calculating 'time difference' between two records....
Posted by iamonthisboat NO[at]SPAM gmail.com at 12/21/2005 1:27:39 PM
I have a data set like so: UTC_TIME Timestamp NodeID Message Flag Line Station 11/19/2005 10:45:07 1132397107.91 1 3 5 1028 1034 11/3/2005 21:05:35 1131051935.20 2 3 5 1009 1043 11/25/2005 21:12:16 ...more >>

LDIFDE csv import to SQL - looking for Ideas
Posted by rcamarda at 12/21/2005 1:00:23 PM
This is a tuffie, but I think I'll learn new techniques in SQL. I wish to put data from MS Active Directory and put it into a table. Specificly I want user information (first name, last name and so forth) and the groups that they belong into a SQL table. LDIFDE is a utility that can create a csv...more >>

OLE DB Provider for ODBC and Oracle
Posted by Crazy Cat at 12/21/2005 7:23:43 AM
Hi, I created a linked server for MS SQL Server 2005 Express to an Oracle database using the OLE DB Provider for ODBC. My ODBC Source uses the Microsoft ODBC for Oracle driver. I'm using the OLE DB Provider for ODBC instead of the Oracle OLE DB providers because those don't handle Oracle's Nu...more >>

SQL/ASP - Timout Problem w/ Particular Statement
Posted by Not4u at 12/20/2005 6:42:54 PM
Hello Config : SQL 2000 on WIN 2000 (IIS 5.0) In my ASP page for some queries i have this error : Microsoft OLE DB Provider for SQL Server error '80040e31' Timeout expired My asp page calls a stored procedure passing many parameters. I used the SQL profiler to get the exact store...more >>

operand type clash
Posted by coop at 12/20/2005 1:58:25 PM
I have a stored procedure that works fine on SQL Server 2000 or 2005, but when run on an machine running MSDE, I get the Operand type clash, int is incompatible with text data type error. The data type is actually text and text is the type of data being passed. Any parameters not being used ar...more >>

one transaction log per filegroup?
Posted by plsullivan63 NO[at]SPAM gmail.com at 12/20/2005 11:00:21 AM
Is a single transaction log created for a database or, if you have a primary and a secondary file group in that database, are two transaction logs generated? Yep, a newbie. Thanks, Phil ...more >>

TransferText dropping fractions
Posted by ckirby NO[at]SPAM mindspring.com at 12/20/2005 9:42:47 AM
I've got a csv that I am trying to import into a SQL Server (2000) table through an adp (Access 2000). The form used gives the user the ability to browse for a file, then will import the file into a temp table for processing using this vba code: DoCmd.TransferText acImportDelim, , "tmpPaTimeC...more >>

Update Web Form
Posted by Cat at 12/20/2005 7:40:26 AM
I'm trying to create a online update form to a SQL table. I've never done this function before, and I'm not quite sure I have the coding correct. Below is the coding for the Update statement. final String udc = "UPDATE INTO " + "Comm_WebSubmission Set ProjectID = request.getParameter("Projec...more >>

time format error
Posted by Johnny Ruin at 12/20/2005 6:38:15 AM
What do you think of a query that generates a System.Data.SqlClient.SqlException when submitted via a application, but when run through QueryAnalyzer or EnterpriseManager doesn't generate a error? Here are 2 examples of the query: SELECT table1.*,table2.field1,table2.field2,table2.field3 FRO...more >>

arbitrarily delete transaction log
Posted by plsullivan63 NO[at]SPAM gmail.com at 12/20/2005 6:36:54 AM
Question: (SQL Server 2000) Can I arbitrarily delete a transaction log file in either bulk or full with a cron job and still be able to restore a backup? Or are the log and the .bak enmeshed to the extent that this not do-able? Details: I need to exclude a file group from a backup as it's stat...more >>

Size of data-set passed back by a select
Posted by Mike Collier at 12/20/2005 6:28:25 AM
When a SQL statement is executed against a SQL Server database is there a server-side setting which dictates the size of the fetch buffer? We are having some blocking issues on a new server install which do not occur on the old server until a much larger volume of data is selected. Any help ap...more >>


DevelopmentNow Blog