SQL Server Tag Directory

Featured SQL Server Questions

Disk Partitioning w/SQL Server 2000/2005/2008
I recently read some information regarding aligning the Disk for use with SQL Server from Mr. Denny. My understanding is, SQL Server handles data in chunks of 64KB, so the disk drive SQL Server writes to containing data and log files should be configured to work in 64KB chunks. The articles I am referring to...

Answer Question   |  April 3, 2014  3:51 PM
Partitioning, SQL Server 2000, SQL Server 2005, SQL Server 2008
asked by:
5 pts.

Getting ORA-29283 error when opening CSV file using UTL_FILE.FOPEN
I have a SQL script and all it does in to open a CSV file using UTL_FILE.FOPEN. I keep getting the ORA-29283 error.  I have an Oracle directory object pointing to the file location. Here is the code snippet: create or replace procedure “SKINNY” as v_inputfile             utl_file.file_type; v_filedata              varchar2(4000) := null; v_filename              varchar2(50) := null;...

Answer Question   |  April 1, 2014  12:24 PM
ORA-29283, Oracle 10g, SQL, Sql Script
asked by:
355 pts.

Import data from Access into SQL Server 2005
Hello, I have a large database on ms access with more than 100 tables. I am planning to do migrate this database into MS SQL Server 2005. I am receiving info into database access on a daily basis. So I have to do an auto job to import data from access into SQL Server 2005....

Answer Question   |  March 29, 2014  10:30 AM
Migration, SQL Server 2005, Stored Procedures
asked by:
77
15 pts.

Adding a field when using SQL to copy a file on iSeries
My company is upgrading some applications and I need to copy the data from current files into the new files. In some cases the new files have additional fields. Is there a way with sql to copy the current data and at the same time add either a default value or a running sequentional value...

Answer Question   |  February 28, 2014  1:21 PM
AS/400, iSeries, SQL, SQL INSERT, SQL0117
asked by:
CLK
35 pts.

P2V Windows XP SP3 SQL Server 2005 Express
Hi all, can I do P2V with Windows XP SP3 and SQL Server 2005 Express? Is that is possible and how? I mean what kind of software if its doing cold or hot?

Answer Question   |  February 17, 2014  8:50 PM
P2V migrations, SQL Server 2005, VMware Converter
asked by:
5 pts.

Exporting vb6 data to pdf using sql select query from ms access .
hi my name is vishal. I think i have a problem in exporting vb6 data to PDF using sql select query(join query from multiple tables). i have a form in which when user selects a GRNno from combobox and then press button with caption:Generate it should generate a PDF report regarding GRNno.Given below is code...

Answer Question   |  February 14, 2014  7:03 AM
msaccess, SQL Select, VB6
asked by:
30 pts.

Flowchart
Can someone help me write a flow chart and algorithm of a program where the user is asked to find an integer number between 1 and 50? Thanks!

Answer Question   |  January 31, 2014  11:13 AM
Algorithms, SQL Server 2005
asked by:
15 pts.

unique next no. generation problem
have to generate unique_number the condition is the user may or may not have system_no which is allocated by the system the user first time start the system/application and if the user format that system the same unique_no will be generated again.this no. comes to our server for user_id and server(sql server 2005) generate an...

Answer Question   |  December 31, 2013  12:28 PM
SQL Server 2005
asked by:
5 pts.

Apps built on SQL Server 2005 running in 2008?
Will applications built in SQL Server 2005 run in a SQL Server 2008 environment

Answer Question   |  December 18, 2013  3:15 PM
Applications, SQL Server 2005, SQL Server 2008
asked by:
5 pts.

SQL 2000 migration to SQL 2005 – need to preserve user security
Hi, I have a customer that is planning on moving to new hardware and performing a SQL upgrade (2000->2005).  I know that our application (FileNet Image Services) is sensitive to what we refer to as an “orphaned” database.  Our app stops working if a database is simply detached/attached to another server because it loses that...

Answer Question   |  December 7, 2013  2:24 PM
SQL Database Security, SQL Server 2000 to SQL Server 2005 upgrade, SQL Server security, SQL Server Upgrade
asked by:
5 pts.

SQL 2005 Security to access 2 databases on same server via Stored Procedure
We are tyring to apply best security practices by only granting EXECUTE security to Stored Procedures connected to a Role and make users members of the role. However the SP needs to access data from another DB on the same server and when trying we receive “SELECT permission was denied on the object”. We have...

Answer Question   |  December 6, 2013  8:33 PM
Database management, Security, SQL 2005, SQL Server 2005, Windows Server 2003
asked by:
15 pts.

Evicted Last Server from 2003 Cluster – Databases won’t start
**First submit blanked out all the original content** Sorry Environment – Windows Server 2003 SP1, SQL Server 2000 .exe version 2000.080.0760.00 I am helping to remove the clustering and migrate all databases on the cluster to a single machine in the cluster. I was able to evict Server 1 from the cluster and all DB...

Answer Question   |  November 26, 2013  9:38 PM
Cluster, SQL Server 2000, Windows Server 2003
asked by:
5 pts.

Source code for multiuser programming in VB 6 with SQL Server 2000
hi to all, I’m developing a security software in Vb 6.0 with Sql Server 2000 as back end wherein 10 users will be there. I’m a newbie in multiuser programming. The question before me is that how to proceed further. My stand alone code is almost ready 50%. I’m using Ado for establishing connection and...

Answer Question   |  November 12, 2013  8:31 AM
Database programming, Multiuser application, SQL Server 2000, VB 6, Visual Basic, Visual Basic 6
asked by:
5 pts.

Pros and cons of running SQL Server 2005 through virtualization on VMWare
I have been asked to provide pros and cons for running SQL Server 2005 on one hardware (VMWare) for multiple groups of DBAs. The proposed plan is to have SQL Server 2005 Standard Edition with system administrators managing the server and DBAs not allowed to logon directly to the server (only through the Management Studio...

Answer Question   |  November 11, 2013  4:52 PM
SQL Server 2005, Virtualization, VMware
2,585 pts.

SQL 2000 & Outlook 2000
We have a couple of SQL 2K Servers which have a mailbox associated with them, have always used Outlook 2000 because anything newer does not work and today it has gone wrong!!! We are now getting a “Cannot open the mailbox, information store not available” we cannot get the server to work with email and...

Answer Question   |  November 11, 2013  2:12 PM
Exchange 2007, Outlook 2000, Server 2000, SQL Server 2000
asked by:
60 pts.

SQL Server view column conversion problem
I have a view with a column SWID. The source column is Varchar while in the view creation it has been cast to INT. The source table has a non-numeric value “CITY”, while during the view creation, this record have been filtered out. When I select all records from the view, it’s working well. However, when...

Answer Question   |  November 6, 2013  5:12 PM
Data conversion, SQL Server 2005, SQL Server Query, SQL Server View
asked by:
5 pts.

SQL Server 2005 Express SP3 Memory Usage
Upon Startup of my system the sqlwriter process immediately grabs 700mb of RAM and holds it. As I use the SQL Server to do different thing the memory usage grows and causes the memory on my system to decline. The SQL Server never releases the memory and it causes my system to respond slowly. I...

Answer Question   |  October 23, 2013  12:50 PM
SQL Server 2005, SQL Server 2005 Express, SQL Server memory, SQL writer
asked by:
5 pts.

SQL Server 2000 Database Table Limit?
Is there a limit to how many tables a single database can hold in SQL 2000?

Answer Question   |  October 23, 2013  8:18 PM
SQL Limits, SQL Server 2000, SQL Server database, SQL Server tables
asked by:
25 pts.

Store and retrieve data from SQL Server 2005 in UTF-8
I am trying to store and retrieve data in UTF-8 on SQL Server 2005 and having problems. I manually type Greek (just for example) into the database and when I open the table SQL makes it into question marks ???. What should I do to be able to store and read UTF-8 data? My columns...

Answer Question   |  October 23, 2013  10:42 AM
SQL Server 2005
asked by:
65 pts.

How to make installer of VB.NET including SQL Server 2000?
I had done my project in vb.net with sql server 2000 but it’s installer doesn’t work properly as it displays the message unexcepted error while connecting to the database.I know setup and deployment in vb.net but doesn’t working please help me.I am stuck in here.thanks in advance.

Answer Question   |  October 23, 2013  11:32 AM
Database connectivity, Setup and deployment, SQL Server 2000, VB Setup File, VB.NET, Visual Basic, Visual Basic .NET
asked by:
45 pts.

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: