SQL Server

Display Bug with CFTextArea?

Is there a bug or a trick needed for cftextarea to display DB retrieved query data? When I try to display a single retrieved MS-SQL varchar value in a cfwindow dynamically created form, I must refresh to see the value. A HTML textarea control on the same form displays properly. Multiple query...

Adding data in SQL 2005 server

i am trying to add data on an sql database from backend problem is it does not acceptnull values kindly help. My email address is edmuia@yahoo.com

view active directory data using SQL server 2005

How could I view active directory data using SQL server 2005. For example I have all of the data available in Human Resource system and I would like to pull some of the information to the active directory like name, position and department … ext where the user name is primary key. Thanks alot...

SQL Server 2005 - Unable to Eun a Pull Subscription due to "unable to connect to distributor" error

I have 2 Windows server (Windows Server 2003) running SQL Server 2005. Server 1 is the distirbutor and publisher. For a snap-shot replication, I have no problems running a push subscription from server 1 to server 2. However when I try to set up and run a pull subscription on server 2. It fails...

Changing the sql server service and agent windows account password

Hello, we are considering changing the sql server service and agent's password. What all should be considered prior to doing this? This will include doing this on 2000, 2005, and on clusters. Thanks!

SQL Server 2005 question self join query

I have one table that name is TblCategory on that 2 columns are CategoryName another column name is UpperCategoryID my table is like this CategoryName UpperCatID ------------ ----------- Book Commerce Commerce Accounting Science Math Commerce B.O....

Exporting SSRS Report in Simple Excel sheet(not formatted)

Hi All, when I export and ssrs report in excel, it gets exported in excel but in a fancy format. I want to export the data in a simple excel sheet format so that I could apply filters or formulaes. If any one of you are aware of this do let me know please. Avhilash.

SQL Server 2008: Difficulty setting mixed mode authentication password

I am attempting to install SQL Server 2008 (64-bit) on Windows Server 2003 SP2 (64-bit). During the installation, I get stuck at the step where it asks for a mixed mode authentication password. Following the requirements, I have tried a strong password but I am still getting the error message,...

SQL Select: Getting the previous records from a known record

I issued a select statement like this: Select phone# from pltlcd where phone# >= 985143525 fetch first 20 records only PLTLCD is a file sorted by phone#. From the first record retrieved by the aboe select statement, how do I get the 20 records in the file that exist before the returned set of...

Encrypt the password in SQL 2000

How to pass encrypted passwords in connection string in asp/vb using sql server 2000. Im trying to create a new user login for the applications using SQL server 2000. However want the end users to avoid viewing the login credentails for sql server 2000 in the connection string part. Hence prefer to...

Estimate SQL Server tempdb space for a query

Database - MS Sql Server How to estimate the amount of space that a query uses in tempdb? I am trying to join certain transaction tables that are really huge - about 300GB. Is there a way I can compute the space that the query might take in tempdb based on factors like: 1. Columns retrieved 2. Join...

Recovering lost SQL Server 2000 data

I lost a LDF file for SQL server 2000 -- but I have the MDF. How can I recover my data?

Error during SQL Server 2000 installation

When I attempt to install SQL Server 2000 using Windows XP Service Pack 2 for IT Professionals and Developers, I encounter the following error: "Microsoft SQL Server 2000 Enterprise Edition server component is not supported on this operating system. Only client components will be available for...

unable to connect to SQL from Access

I want to create a new database on SQL Server 2008 from Access 2007. I had no problem before I updated to vista from XP professional. When I test the connection, no problem, however when I try to create the database I get the message: The new database wizard does not work with the version of...

Filling data in datagridview in vs2005 with windows develpment

HI all I have a more than 80000 data in sql server 2008 in a single table. Then i have to show that data in datagridview. But the performance has very slow some time my machine hang. It has taking several minute. So i have to improve this performance could anybody help me. For information i am...

SQL Server tables - What account created the object

Is there a way to see who created or droped a table in sql server?

Refresh/Run SQL

We upgraded to Crystal Reports 2008. Our older version queries appear to work... In the Older Verion all we did is click the lightening blot. Now... we have to go through Database, SQL to run/refresh the query. Isn't there a one click key for to run these queries?

Memory overhead recommended for benchmarking SQL server 2005 on vSphere

For a 'direct' physical to VM comparison of SQL server 2005, would anyone recommend giving the VM extra (say, 1.5GB) RAM to compensate for any overhead the OS needs? So a direct comparison would then be 1vCPU, 2.5GB RAM VM & SQL set to use 1GB RAM) vs. SQL on physical host set to use 1CPU and 1GB...

SQL Server: Index and Key

What is the difference between a key and an index? Whe I issue a SELECT statement, and the table has an index, do I still have to use my key?

SQL select command

Hi i hope all doing well, i have a problem with this SQL select command : **************************************************************** SELECT DISTINCT customers.first_name, customers.last_name, customers.email, customers.cellPhone, customers.phone, items.title, items.price,...