Binary Math windows server 2008 sql server 2008 r2
Operating System: Windows 2008 2 Database: SQL Server 2008 Enterprise R2 issue: I am trying to creat a binary matrix that manages user permissions. My largest number at present is 135069719 the binary representation is : 101001001110000101001 The largest number I eventually have to handle is a 20 digit decimal number Is this possible?

Answer Question   |  June 23, 2012  3:33 PM
Binary Math, SQL Server 2008 R2, User Permissions, Windows Server 2008

Cost to upgrade to MS SQL Server 2008
My company is implementing new features in our product line that will force customers to upgrade to SQL Server 2008. I can’t make sense of MS’s pricing for SQL Server upgrades any longer (i.e., it seems they’ve gone away from the notion of a SQL Server ‘upgrade’ license). Does anyone know a ballpark figure for [...]

Answer Question   |  June 16, 2010  3:51 PM
SQL Server, SQL Server 2008, SQL Server licensing, SQL Server Upgrade

Backup storage for sql server 2005
1.create database ABC 2.backup database ABC to disk=’D:backupDBABC.bak’ Here i created a new database ‘ABC’.NOW my DATABASE is empty(no objects where created), i am taking full back up,the out put i am getting OUTPUT: Processed 152 pages for database ‘ABC’, file ‘ABC’ on file 1. Processed 2 pages for database ‘ABC’, file ‘ABC_log’ on file [...]

Answer Question   |  June 16, 2010  3:19 AM
Backup storage, SQL Server 2005, Storage in 2010

ACCESS ERROR CHARACTERS FOUND AT THE END OF SQL STATEMENT
I tried example 6 from the book SQL for Microsoft Access and got the error message” CHARACTERS FOUND AT THE END OF SQL STATEMENT. I tried deleing the first semicolon and got a message: missing semicolon at end of SQL statement. Can anyone tell me what I am doing wrong? Thanks, INSERT INTO Toys (ToyID, [...]

Answer Question   |  June 8, 2010  5:33 PM
Access errors, Microsoft Access, SQL, SQL Access

To write a stored procedure
there are two tables one ZipCode and one tempTable each has ZipCode and CongDist as columns. Each Zipcode has more than one CongressionalDistrict. How can I write a SP to have a seperate entry for each senario of Zipcode and Congressional District in tmp Table

Answer Question   |  June 10, 2010  1:49 PM
Relational databases, SQL Server stored procedures, Stored Procedures

SQL server query to search for table and column data in database
I want to find the data in a table,but i dont know the table name and column name.All I know is the data and the database name .Is there a query to find the table and column

Answer Question   |  June 9, 2010  4:40 AM
SQL Database, SQL Developer, SQL development, SQL Server Query

SP Dynamic SQL with LIKE Operator
Hi. I want to create a stored procedure whereby the variable comes after the LIKE operator. For example, the code would look something like this: CREATE PROCEDURE SPFIND @VARIABLE1 VARCHAR SELECT * FROM TABLE1 WHERE FIELD1 LIKE ‘%@VARIABLE1%’ Then to execute the procedure, EXEC SPFIND ‘VARIABLENAME’ I can’t get this to work using the LIKE [...]

Answer Question   |  June 8, 2010  12:38 PM
Dynamic SQL, SQL Server 2005, SQL stored procedures, Stored Procedure variables

SQL Server 2008 Management Studio evaluation edition a time bomb?
Hi, I was just wondering if the Management Studio for SQL Server 2008 evaluation edition is also a time bomb? One of our client wants to just install the 2008 Management Studio and I was just wondering if we could use the Evaluation edition or do we have to purchase a license just to get [...]

Answer Question   |  June 16, 2010  5:29 AM
Management Studio, SQL Server 2008, SQL Server licensing, SQL Server Query

SQL Server partitioning
Hello Sir, i m creating a partition  as  use master go create database mypartpracdb214 on primary (name=db_dat, filename=’c:partitionpracticedb.mdf’,size=4mb), –filegroup fgi –(name=fgi_dat,filename=’cpartitionpracticefgi.mdf’,Size=2mb), filegroup fg2 (name=fg2_dat,filename=’c:partitionpracticefg2.mdf’,size=2mb) log on (name=db_log, filename=’c:partitionpracticelog.mdf’,size=2mb,filegrowth=10%); go create partition function partfunc (int) as range left for values(1000,2000,3000,4000,5000) create partition scheme mypartschm as partition partfunc  to ([fg1],[fg2]) After executing the partition scheme code it [...]

Answer Question   |  June 7, 2010  12:37 PM
Partitioning, SQL Server, Storage in 2010

DBFs into SQL Server 2008
Does anyone know of an efficient way to import DBFs into SQL Server 2008 (besides the “import into Access, then import the Access files into SQL server-method”)? I don’t work with SQL Server much, but I do it enough to have had this problem before (to be exact, it seems I have this problem once [...]

Answer Question   |  June 4, 2010  3:28 PM
DBF file, SQL Server 2008, SQL Server import/export

SQL indexes
hello, there are many indexes clustered an non clustered .so how can i see the result of each index, clustered and non clustered seperately through (T-SQL) pls guide me. RINO

Answer Question   |  June 8, 2010  12:21 PM
sql indexes, SQL Server, T-SQL

Using stored Procedure in SSRS
Hi…. I am trying to create a Report using Report wizard in MSSRS 2005, I am trying to use Stored Procedure. The steps which I am following are below…. Solution Explorer–> Add New Report–> Next(as DB is already shared one)–> Query Builder (But when going into query builder the command text is disabled and I [...]

Answer Question   |  June 3, 2010  8:24 PM
SQL Server 2005, SQL Server Stored Procedure Migration, SSRS, Stored Procedures

Import data file into SQL database
I need to import tis .dat file into sql database table having four column client-007092~WITCO clname-CORPORATION ,matter-0005,mattername-LAZY OIL V. WITCO

Answer Question   |  June 1, 2010  4:38 PM
Data File Utility, SQL Database, SQL Server database

Backup Exec
Hi I have Backup Exec 20210 installed on a windows standard 2008 server 64 bit. At first it ran ok and allowed me to setup a backup schedule, now when I try to run it comes up with the following error ,HERSULT: 0X8007000B)  I have SQL 2008 installed on the server but we have a [...]

Answer Question   |  November 9, 2010  7:55 AM
Backup Exec, Backup Exec Error Messages, SQL 2008, Windows Server 2008 64-bit

Spatial query optimizing
I have a development machine and a production machine with identical databases, but I’m getting huge differences in execution plans when running a spatial query. First, my development machine: It’s SQL Server Express x64 with Reporting Services running on Win7 with 8Gb RAM. Then my production machine: SQL Server with Reporting Services running on Windows [...]

Answer Question   |  June 2, 2010  11:32 PM
SQL Server, SQL Server Express, SQL Server query optimization, SQL Server Spatial Data

Virtualizing SQL
Is it possible to run SQL Server 2000 on a VM on a workstation? If so, anything special to consider?

Answer Question   |  May 29, 2010  2:05 AM
SQL Server 2000, Virtualization, Virtualization in 2010, VM Workstation

SQL 2005 Database Compare
If there a way to compare two similar database to find where a Stored Procedure is different between the second database. Different in it not there or the Create Date or Modify Date is different?

Answer Question   |  May 27, 2010  5:24 PM
SQL 2005, SQL 2005 Database, SQL Database, Stored Procedures

Subquery only returns column names
I have the query below, but when I run it, I can only get column names to return. Can someone please help me??? For each subject there are multiple values at each marker. I want an average, by date, for each subject at each marker. I have spent literally hours on this… Thanks in advance [...]

Answer Question   |  May 27, 2010  12:42 PM
SQL Query, SQL Server Query, Subquery

Sql Server CAL
I have a Sql Server Enterprise 2005 64X, installed licesed by processor, I what to cut budget so thougt if I change to CAL licensing could save money, but know how to calculate how many users are currently conecting to my server. How can I get this info?

Answer Question   |  May 27, 2010  9:29 PM
SQL, SQL Server, SQL Server CAL licensing, SQL Server Enterprise Edition

How to find who called a stored procedure
I would like to know what process or stored procedure called one of my stored procedures. Is there any way of getting this information from SQL Server 2005? Thanks in advance, Ed

Answer Question   |  May 28, 2010  2:37 PM
SQL Server, SQL Server 2005, SQL Server 2005 SP3, Stored Procedures