Hi, I have some unrelated questions borne from my studying of sql server internals. They are probably stupid but I am new to sql server. 1. On an insert, select, update, or delete of table rows, if the rows are not already in the buffer cache does sql server take the effected rows and put ...more >>

Is SQL Server ever going into competing in the Grid Computing space like Oracle ? ...more >>

I have run into two situations in the recent past that both have the same thing in common. I have to preface this with the fact that I am running the following queries in a C#/.Net environment using SQL Server Express... The question is, and it may be silly, but, should one query for the exis...more >>

I posted this problem some time ago. Please refer to the following link. http://groups.google.co.uk/group/microsoft.public.sqlserver.programming/browse_frm/thread/959fb2cfc19bb8e2/d215bcbd057d7ec5?lnk=st&q=&rnum=1&hl=en#d215bcbd057d7ec5 The following gave me what I wanted at the time: SELEC...more >>

Given this query, how can I rewrite it to make it more indexable: SELECT tableUID FROM MyTable WHERE DateDiff(D, mydate, GETDAT()) BETWEEN 0 AND 29 -- Message posted via SQLMonster.com http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200608/1 ...more >>

I NEED SOME SERIOUS HELP I deleted a production database accidentally, because the person who created named it test, so I figure that it was ok to deleted. Well we don't have any type of backups for this Database. I need to know if there a tool out there can retrieve these files from a ...more >>

hi again where (in which place) stored procedures are stored ? thanks -- atte, Hernán ...more >>

Is there any way I can created a linked server in 2005 and then refer to it via an alias? The linked server I need to create has a lengthly name plus I need to specify a port. It would be much easier to simply create a short alias name for it. Thanks - Amos. ...more >>

How do I determine if SQL Sever Login is disabled using T-Sql? I can disable it and enabled it using the following T-Sql function: ALTER LOGIN login [ENABLE | DISABLE] I just want to know if it is enable or disabled? ...more >>

Hi All , I have installed SQL Server 2005 Developer edition but I am not able to see the Management Studio utility. Is there something I am missing or I have to run some other tools? Thanks in Advance , -Vivek ...more >>

Can you format a partition as "dynamic" and use SQL server on it? I currently have a windows 2003 server connected to a SAN. Local disk (drive C) on the server is a basic partition. drives D and E are on the EMC storage but partitioned as "dynamic". Before I get too far, will I have a problem ...more >>

Hi, new to sql and need help with some script. My current table is a list of names, and a list of associated lifespans(in months I would like to add a column (months) that goes from 0 to lifespan. What table looks like now: Name Lifespan a 5 b 3 c 9 .......more >>

I feel that there is something wrong with my SQL setup. I logged into to the server with the same account as the server and agent are using, installed outlook2003, then opened control panel, selected MAIL, created a profile with the same name as the login that is used for the agent and serv...more >>

We have a SQL 2000 Server that also uses SRS 2000. We are in the process of moving/cleaning up our SRS, and in the process would also like to upgrade to SRS 2005. This is probably a really stupid question, but if SRS 2005 is on a separate box from the SQL Server that houses the database from w...more >>

hi i have the A-app writing in server SQL01.db.Person table and B-app writing in server SQL02.db.Person table i need to replicate in two ways with no overlapping-- what approaches can i take ? thanks -- atte, Hernán ...more >>

I have a table that stores a lot of data, as old as 10-1-2005. Query performance is a pain so I needed a way to increase performance but retain the data. I just started looking into partitioned views yesterday. So I partitioned the table by month, which yields 11 new tables so far, each con...more >>

I have a query on a very large database that when I run this query it takes 1 second to bring back data based on 2 months worth of data. As soon as I run the same query on 1 Month of data (based on a date field that is indexed) the query takes 7 minutes to run. On the excution plan it does not...more >>

We are in the process of migrating our MS SQL Server 2000 databases to MS SQL Server 2005. We have using the MS Upgrade Advisor to flag problems in our databases so they can be fixed. Does there exist a tool from which we can get a report on which databases contain components (tables, colum...more >>

Is there a way to change the report body size in execution time(from the template), depending on the result of an expression?. -- Eduardo Fonseca...more >>

Hi, I'm planning to install the cumulative hotfix (build 2187) on my sql 2000 clustering server (SP4, 2040). And I would like to know if the cumulative hotfix is able to roll back. If possible, please provide me any information about that. Thanks in advance. ...more >>

After upgrading two of my SQL2000 databases to SQL2005, I see the following error when running dbcc checkdb (which runs dbcc checkcatalog): Msg 8992, Level 16, State 1, Line 1 Check Catalog Msg 3853, State 1: Attribute (role_principal_id=16384) of row (role_principal_id=16384,member_princip...more >>

We are in the process of converting our existing in-house asp web sites to Sharepoint. Our existing web site has many PDF's, images, etc. These all reside on the server in a Folder\file. Since Sharepoint now a database driven architecture, I was wondering if anyone could assist me with som...more >>

Hello, I have this query that was written for Oracle, but when I run it in MS SQL I get */*** ERROR *** Line 9: Incorrect syntax near 'start'. I can't seem to figure it out, can you someone please point in the right direction? select 99, login_name, (full_name) from shr_wr_approvers wh...more >>

I have a DTS that exports a view to an excel file, is it possible to append data to an excel file, it seems if it sees that the sheet is available it creates a new sheet, I have a logo in my excel file and I want to append the rows below it. ...more >>

Looking for suggestions on how to get around a problem with loading data into an Oracle table from a tab delimited file. The problem is that the file is sent by a customer, and to be nice I'd say it's not formatted very user friendly. In the 'flat file connection manager, I'm able to select ho...more >>

Hi, In EM, the following two groups are allowed to access the database DEPT. dept_staff dept_staff_parttime Group 'dept_staff' has the deptadmin server role on the DEPT database. The deptadmin server role can do anything on all the tabless of the DEPT database. In the active director...more >>

I have multiple jobs that simply fail to start (all of them). The agent is running, and the jobs will start for a few days or weeks, then mysteriously just stop working. Manually starting the jobs fails to start them and no visible error message appears. Restarting the server does get th...more >>

When I try and do a maintenace plan to backup all databases there is one that does not get backedup. All the others seem to work fine. So I try to make a new maintenance plan to backup only that database and when I try and create the plan that database is not in the list of databases. I sup...more >>

Hello, I have been somewhat forcibly involved in a project to migrate a SQL Server 2000 installation to an x64 SQL Server 2005 one. All seems well, except we have an old Informix server on our network which is configured as a linked server on the old installation. I've been 'reliably' info...more >>

This is for a data entry / batch processing system using SQL Server 2000 that is used heavily during the working day throughout the year. Currently we do a full backup to disk at 2am every morning, and transaction log backups to disk every 2 hours between 8am and 10pm. We normally only hold...more >>

Is there a difference in SQL Server 2005 64-bit versus 32-bit from a development or management point? I realize that there are differences in the hardware requirements and that there is 32-bit, X64, and IA64 versions. I wanted to know if sp's, back-ups, data types, queries and functions all ...more >>