Hi guys, Recruiter here. In any case I am on the lookout for folks who happen to have skills with MS reporting services for the past year or so. They also need to have a bunch of other Datamart | Datawarehouse type skills. I dont know why I am having so much difficulty with this sort of th...more >>

Hello, We have a problem with a "primary group is full" error, this is a well known problem found by Google but the only thing is that the solutions or problems with low diskspace is not our problem. Also solutions related to hotfixes wouldn't do the trick. As we have SQL Server 2000 SP4 runn...more >>

For reasons of convenience I am importing data into a table, include a dates, where all fields are text data types. When I try to then query the database, converting a field into a datetime (with convert) I get the following error: "Arithmetic overflow error converting expression to data typ...more >>

Is there anyway of determining who created a SQL Server Job? ...more >>

Dear All: For some special reason, I need to install Reporting Service Enterprise unto SQL Server 2000 Standard Version. Is this possible? Joel ...more >>

I am running windows xp pro on my home computer and would like to test an database driven ASP .NET web application. I need to be able to create an SQL database which will be assessed by the web application. I already have a local IIS Server up and running. At work, I use SQL Enterprise Mana...more >>

I'm not 100% sure if this is the correct area to post this topic, but I'll give it a shot. I have just started working for a new company and came in a huge scuffle between Network Admins and SQL Programmers. The problem is the programmers want full administrator control on the sql server, but...more >>

I would like to dump each of the stored procedures in one database to a separate file. Programmatically would be great (e.g., start with SELECT * FROM sysobjects WHERE xtype='P'), so that I can have greater flexibility. My last resort is to use some tool already written by somebody else tha...more >>

I want to design a physician appointment database. I want to design the time in day as an entity, with days of week (like sunday) and holiday status of day (0 or 1) as its attributes. How I can fill its table for a known period like the next 3 months without using a diary? For example today is ...more >>

Hello, I am new with SQL server and I would like to convert my Access 2003 database to use with SQL 2005. I know there is a tool in MS access called Usizing Wizard to help me to do this, but can this tool convert Access Forms, Querries and Reports to SQL as well? One this database is migra...more >>

Hi all, I am using sqlconnection in .net and opening connection at the begining of application and closing it at the end. But some time i am getting error. 'Invalid operation. The connection is closed.' can someone tell me reason behind this error. Please tell me as this is very very i...more >>

is it possible to select colunm dynamiclly from a table based on given parameter?? ...more >>

i'm trying to get total rows found by query that uses top clause... for example: select top 10 myTable.* from myTable where myTable.number > 200 let's say there are 13 rows matching that condition, and by using @@rowcount my result would be: 10. is there any way to get total row count, ...more >>

i tried to install it but on installation options, only show two avialable options, which are really just Client and document. if i try to install on a real machine (instead of Virtual machine) i can see all the components. ...more >>

Hi, Can any one help me with syntax of INSERT INTO Statement for inserting into binary columne of the table. I have read multiple articles using stored procedure. I need to embed that binary data in INSERT INTO Statement. Please help. ...more >>

What is server execution plan ? what is the use of it ? ...more >>

Hi all. Let's talk in the abstract for a minute. I've got a 2000 instance of SQL Server in _my_ domain, and I've got another instance in _their_ domain. We're talking about a third-party domain controller that I can RDC into via 192.168.XXX.XXX. My company owns the server, but the third par...more >>

Hi People, I'm in the lucky position of building a database from scratch for my company in SQL 2005. We have a situation where we have customers and each customer can have a child customers and so on and on. So the best way I found of doing this was putting everything in one table called "C...more >>

hi, I'm having an issue with backup of Sql Server 2000, We've organized an automated backup of Sql Server 2000, The Server is running constantly, the Service Agent is running constantly, the backup is sheduled and seems to be running fine but when i look at the Backup files timestamp it doesn...more >>

Hi, I have a table with 3 columns, "id", "text" and "author_name". Let's say the table has 1 row like this id text author 1 "behavioral targeting" "roger" So when I search for 'behavioral and targeting and roger', there's no result shown cause no...more >>

Looking at the following two tables... orders: id type identity description type varchar(40) tasks: id type identity id_order type int (linked to order.id, many to one) req_start type datetime req_end type datetime .... I would like to be able to output rows containing the id o...more >>

I declare a table as follows: create table test(ColOne FLOAT(53)) Then try and insert into it with: insert into test select 0.000000000000000000000000000000000000000000001401298 which fails reporting: The number '0.000000000000000000000000000000000000000000001401298' is out of the range...more >>

Is it possible to connect to 3 database and execute a cross db query? I usually use SqlConnection(connectionString) for a single connection ...more >>

my client wants to be able to pull records for contributors based on months since their last donation. so, i have to select max(contributionDate) and then determine the number of months since that date until today's date using dateDiff. this is giving me incredibly slow performance (2.5 mins to p...more >>

Hi, I have installed SQL 2005 on my Windows 2003 box. After I install SQL 2005, I have configured the Reporting Services and I can connect using the Management Studio. I had to rename my machine and after I renamed I can still connect to Database Services from Management Studio. However I a...more >>

I'm trying to write query to find stored procs that may be used in a DTS package. I have used the following for finding stored procs in jobs. I was hoping there was something similar for DTS. -- run in the msdb database. select j.Originating_Server,j.Name,j.Enabled,s.Step_Name,s.Command,j....more >>

We have recently started archiving data in our database. With some of the tables that I've archived I see a reduction in the physical size of the table when I delete rows. In other words if I delete 50% of the rows the amount of disk space the table uses also drop by close to 50% But there are...more >>

Hi, is it worth to use an index on a table that will have about 200 rows max. I tried to add a clustered index on one of the fields, the query plan showed improvement, but I still think it is pretty useless to add a clustered index on a non-selective char(1) field. Although the query plan showe...more >>

Hi, I have a content based site with over a 1000 downloadable word docs which are currently stored on a server filesystem. however these are split in muliple folder paths for different clients and i am trying to find a more efficient way of doing this. i have been looking into storing the fi...more >>

Hey everyone, We are running MSDE on a Windows 200 server and it has data in it. What I would like to know is can we also install MSSQL 2005 on that server and have assess to both databases. Is there anything we have to do to install it and make sure it doesn't overwrite or delete the MSD...more >>

i've written two functions that return the dateDiff in months or years. if i use the dateDiff month function in a where statement, i get incredible slow response times (2.35 seconds vs calling the dateDiff year function which returns the results in 1 second). the two functions are almost exactly ...more >>

I have the SQL sever 2005 enterrpise version installed, then after start from management studio, i am not able to connect to any local database, even i run create sample database, but seems i can't find it from local server. did i miss something? also, do the enterrpise version includes Report...more >>

Hi all, I would like to know the best way to schedule the FullBkps and LOG Bkps, to minimize data loss in case of crash I have 1 'Backup Device' for DBBackup and one 'Backup device' for my LOgs. See below my actual schedule sequence Time 00:00 LOG BKP (overwrite) time 01:00 FullBack up...more >>

Hello I'm wondering about a few SQL best practices, and which one is faster/better: 1. INNER JOIN VS. NOT USING INNER JOIN SELECT A.VAR1, A.VAR2, B.VAR3 FROM TABLE1 A, TABLE2 B WHERE A.QID = B.QID VS. SELECT A.VAR1, A.VAR2, B.VAR3 FROM TABLE1 A INNER JOIN TABLE2 B ON A.QID = B.QID...more >>

Hi all, i have a simple question.. I have a DB with FULL recovery model. My Log file grows too faster, and I have to backup it regularly (each 8 hours), but I would like to Know how can i free the space used by the Trans Log after backup I mean, my xxxx_log.ldf is about 13GB, after backup it...more >>

Hello SQL 2005 Experts, On a win xp sp2 box, I installed VS 2005, which also installed an express (or dev) version of SQL 2005. Then I installed the SQL Server 2005 Enterprise. The default db is [comp name]\SQLEXPRESS. I am trying to create a publication (right click on replication, ne...more >>

Hello, I have a VLDB backup job which is setup to delete files older than 12 hours. It fails daily with an insufficient space on the disk error because it is not deleting the old backup. It is not a permissions/security issue. I can setup the same job on a smaller database on the same server...more >>

If I update several rows of a table with a query, the update trigger on the table only fires once, for the last row updated. Is there any way to get it to fire as each row is updated? Alternatively, can I detect which rows have been updated when the trigger fires? John Franklin ...more >>