SQL Server

How does SQL Server 2000 CAL licensing work

Hi, Just wondering how SQL Server CAL licensing work. For example in one of our client SQL Server 2000, we notice in the SQL Server 2000 licensing icon in Control Panel, it is set to CAL of 50. Does this mean if the 51st client tries to access the SQL Server, an error will occur? Thanks in...

The most-watched IT questions this week: Oct. 6, 2009

Once again, we’ve compiled the 10 most watched questions on ITKE, and found some great discussions on topics ranging from virtualization to disaster recovery to disaster recovery. Go answer a question now and you could win a TV, or check out the rest of the top 10 on the Community Blog: 1. How...

Change SQL Server licensing

Hi, I was wondering if it is possible for a 50 seat (i.e. maximum of 50 connection) SQL Server 2000 or 2005 license to be change to a 10 seat? If it is possible is there any limitation on the number of seat that can be change? Thanks

SQL Script with hyphen in the value set

We have a particular piece of malware that will put some binary code in the HKLM/System/ControlSet001/Services/{5083B7D5-47AF-8FF9-657C651C2B10}/ I am using an sql script along with Microsofts logparser to parse some data out of the registry on a windows box and I am having trouble with the last...

vb.net 2008 and sql server 2008

How can i connect to the sql database using the app.config file over a network and also have the ability to edit the app.config during installation or when the application is installed on another machine on the lan Software/Hardware used: vb.net 2008, sql server 2005

Reordering the Table position in SSRS

Is there any provision to reorder the table position in a rdl? I have two tables, say A and B where A is placed after B at design time. Can I reposition them with B coming first and then A at run time? Software/Hardware used: SSRS 2005

Oracle LIKE statement on SQL Server 2005

I'm trying to execute the LIKE statement but it's not displaying  any values SELECT R_NAME FROM LAWSON.DEPTCODE WHERE (R_NAME LIKE :r_name) Software/Hardware used: oracle 10g

installing sql server 2000 32-bit on vista 64-bit

how to install sql server 2000 32-bit into vista 64-bit? Software/Hardware used: window vista business 64-bit, hpi7

Best way to copy large amount files

I have 50 GB of files on an iServer that was copied onto an external hardrive.  What is the best way to copy these files onto a Seagate NAS Server.  The external HD is plugged into the USB and appears as a drive.  Should I use xcopy is DOS or can I drag and drop in windows SP? Software/Hardware...

SQL 2008 Security: How do I give users access to just views within a DB?

[h1 class="subject"] [/h1] I have inherited a SQL DB and need to give a group of users access to some views within a DB. We do not want them to access the tables, just the views. They will be connecting using MS Excel for reporting purposes. Do I use a role or schema? What is the best practice to...

How to Edit SQL 2008 RDLs to run on a SQL 2005 SSRS Server?

Has anyone figured out how to edit a SQL 2008 RDL to run on SQL 2005 SSRS server?  Mr. Denny (see link below) believes it can be done. http://itknowledgeexchange.techtarget.com/sql-server/you-cant-deploy-a-sql-2008-ssrs-report-to-a-sql-2005-ssrs-server/ Software/Hardware used: SQL Server 2008...

The IT Blog Top 10: Oct. 1, 2009

10. Choosing a block size when creating VMFS datastores Eric Siebert provides a guide detailing how to choose a block size for VMFS datastores. 9. Using VRDP to view VirtualBox virtual machines remotely Rick Vanover walks through Sun’s xVM VirtualBox’s ability to tap into VRDP remote viewing. ...

Database Views in SQL Server

When I open database expert and open a new DB connection, only tables and stored procedures are shown. How do I get views to show? And yes, I did select views under options/database. Software/Hardware used: SQL Server, windows xp and server 2003

Working TRIGGER and TRANSACTIONS QUESTION

Hello all, My company purchased an operations software (called [strong]darwin[/strong]) that works with SQL 2005 Server. I need to extract some data and save it in my Own Database, which is located in the same SQL Server. On the darwin software there is a screen that updates a field X in a...

SQL Server 2005 is running slow

SQL server 2005 is running very very slow while it hase 32 GB ram 200 GB SAN and 4 Processor of xneon 566 Ghz. The normal select query takes 30-35 seconds to returing 37 records. Please give me the suggestion how to increase the performance Software/Hardware used: OS-window server 2003 R-2,...

SQL Server 2000 hang and shrink won't stop

I'm troubleshooting a SQL 2000 database problem. It's a db for our datawarehouse system that pull everyday data from host. Current size is 461Gb for db and 67Gb for log. Because of space concern, I want to detach the log file and create new, but today I cannot open the database locally or...

Getting last entries from two different tables

Hi, I need to get the last entries from two different tables in MSSQL. I can get the last entry for one table by usung the following. SELECT * FROM dbo.Shaft_Scales WHERE dbo.Shaft_Scales.ID = (SELECT max(ID) from dbo.Shaft_Scales ID) The problem is adding another table. Please help

SQL error

I've a cursor to fetch date from DB2/400...When date is stored as 0001-01-01, I get error - Year portion of the Date not in correct range. This is the default date my update program stores when user doesnt enter anything for date field. How can I bypass this error while fetching SQL cursor in my...

how to use sql server 2005

i have installed sqlserver2005 but i want to know how to open sql server and connect DB

Error when insertin.g data into SQL table

                I'm using SQL Server 2005 Express edition as the Database and Microsoft VB.NET 2005 as the programming language for my project. At the moment I'm having a problem of inserting data into one of the tables in my database through my VB.NET application. I...