|
sql
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Microsoft SQL Server Administrationmicrosoft.public.sqlserver.server
Performance issue
Iter -
12 May 2007 7:05 PM - 2 messages
In my company, we have a central database and 4 remote databases. the central database replicate same database into 4 remote database in parallel. the replication is transaction replication and the data is input in the central database and replicated into remote databases. there are some ...
append backups and other mtn plan stuff
childofthe1980s -
12 May 2007 4:30 PM - 2 messages
Hello: I am editing a backup maintenance plan. For some reason, the plan is doing an append backup. I realize that the word "Append" appears in the window. But, it is grayed out. So, I cannot edit it and choose "Full". Any ideas on ...
Veritas SQL Backup
sharman -
12 May 2007 1:08 PM - 8 messages
My company has started using Veritas Net SQL Backup for all the SQL Servers. These are Weekly Full (weekends) and daily Incremental Backups. If I do a Full Backup in the middle of the week would it affect the Incremental backups ...
cloning a db under another name
GaryDean -
12 May 2007 1:24 AM - 5 messages
I have a database called Paris. I want to clone it but I want the new name to be Milan. I tried creating a new database named Milan and restoring Paris over it but Management Studio would not allow this. I had overwrite ...
SQL 2000 database engine restart issue
ken.runner -
12 May 2007 12:36 AM - 2 messages
We are using Windows 2003 Enterprise SP1 and SQL 2000 sp4 with patches (I believe the latest public build available) When we restart SQL server we have multiple databases that go into a long recovery mode with the following type of message in the ...
dbcc freeproccache only solution???
Chris -
11 May 2007 10:55 PM - 4 messages
Recently upgranded to SQL2005 sp1 Daily we have times of very poor performance. We tracked down to full table scans occuring, indexes not used. Perform a dbcc freeproccache to solve. Any idea why this is occurring? Happening more often since upgrade - did notice same issue when on sql2000... ...
the effects of ALTER INDEX REBUILD on SAN Level replication
sql411@nospam.com -
11 May 2007 9:15 PM - 2 messages
Hello. I am trying to setup DR between east coast / west coast. One option is using SAN block level replication for my databases. If you do any index rebuilding (DBRINDEX or ALTER INDEX REBUILD) all pages are moved around and ...
WSUS connection from SQL client
wit1 -
11 May 2007 7:35 PM - 2 messages
I have an WSUS setup (without installing full blown SQL server), on a Windows 2003 box. How can I connect to WSUS database from another machine (using SQL 2000 Client). here is the SQL log, (where SERVER3 is the actual name for my Windows 2003 ...
SQL 2005 Database Mail PKI Enrcyption
Daniel Jameson -
11 May 2007 7:29 PM - 3 messages
Hi, Does anyone know whether SQL 2005 Database Mail supports sending e-mail with PKI asymetric key encryption? I would like my database server to e-mail sensitive information to users on a scheduled basis. ...
Profiler Replay timing
FredDBA -
11 May 2007 5:49 PM - 4 messages
using SQL Server 2005 profiler, I would like to simunlate the Prod activity into another server. It seems that when I replay the logs it goes all the way down "as fast as possible" without regards of the timing. Let's say I trace 3 queries with a 30 secs ...
Unable to step into SQL 2005 SP from VS2005
Jordan -
11 May 2007 5:28 PM - 3 messages
I'm running VS.NET 2005 SP1 + Vista SP Enhancements on Windows Vista Home Premium. I have a connection in my VS.net 2005 server explorer to a SQL 2005 database. It's using Windows Authentication and my account is a member of ...
Help - "Could not allocate space for object as the secondary group is full" error
pradeepln -
11 May 2007 3:56 PM - 4 messages
Hello Peers, We have a database in SqlServer 2K with a following settings: Primary Group Size: 1024MB Secondary Group Size: 1023 MB Transaction Log size: 236 MB File Growth: 10% Recover Model: Simple Auto Shrink: OFF Recovery Model: Simple ...
Performance
sharman -
11 May 2007 3:55 PM - 7 messages
Hi, Our production server is running very slow. A query on Staging server takes less than 1 minute is taking more than 8 minutes on Production. It's the same with all the databases on Production server. I have looked and found that ...
autogrow speed
bing -
11 May 2007 3:49 PM - 5 messages
Hi, SQL 2000 We set up all of our databases to autogrow 10%. Given a 4G database, how fast would 10% autogrowth be? How can I get notified via e-mail whenever autogrowth occurs? Would autogrowth be logged in the SQL 2000 server log? ...
Nic Card Preferences
eric.c.smith -
11 May 2007 3:30 PM - 9 messages
WE have three sql servers that talk to each other and pass text files. All three are connected to the lan and also have GB crossover cables connecting them to each other. We have certain processes that run that we want to use a specific connection (crossover) to a ...
SQL 2005 - can't see database in maintenance plan
esource -
11 May 2007 3:24 PM - 3 messages
I'm running SQL server 2005 full enterprise version and I have 2 databases added to one instance. When I'm creating a maintenance plan with a backup task I can only see one of the databases when I choose ...
Why is my SQL Server 2005 Express database read-only?
Angus -
11 May 2007 2:02 PM - 5 messages
Hello I attached a SQL Server 2005 database from another computer. I did Detach and Attach on new PC. But the database I attached appears in the Management Studio Express program as Read-Only. How do I make it writeable? ...
How to attach a database using SQL Server 2005
Angus -
11 May 2007 11:52 AM - 6 messages
Hello In the full version of SQL Server I can use enterprise manager to attach a database. I have an SQL Server 2005 database from another machine which I want to attach to a new computer with SQL Server 2005 Express. Is there a ...
More info on SQL Server 2005 Express problem install
Angus -
11 May 2007 11:08 AM - 3 messages
When I run the setup there is a System Configuration Check page. I get 13 successes and 2 warnings. The 2 warnings are: Minimum hardware requirement - there is about 37GB free space, 512MB memory, an Intel Pentium 4 2.4GHz CPU. ...
Problems getting SQL Server 2005 Express to run on my XP Pro PC
Angus -
11 May 2007 10:46 AM - 2 messages
Hello I have installed SQL Server 2005 on my XP Pro PC but I can't get it to run. If I go into the SQL Server Management Studio Express program in the Server name dropdown there is nothing displayed - even if I browse. But database ...
I have to test Log shipping
dotnetcraze -
11 May 2007 9:57 AM - 3 messages
Hi I have to test the log shipping functionality. What all scenario's should i cover? ...
Dts package that imports difference
italic -
11 May 2007 9:21 AM - 10 messages
Hi, I have to server and two different database on them. I want to import one table from database1 to database2. But I want to import only difference between two table.I want to also keep identity column value. I created a dts ...
Maintenance Plan: Backup Database Task (Backup Transaction Log opt
JuanSa -
11 May 2007 9:17 AM - 2 messages
Hello. I have an issue making transaction logs backups with the Backup Database Task within a Maintenance Plan. (1) When I check the option to backup trn logs of all users databases, all databases or any selection, then save the subplan and reopen the task ...
How does UPDATE statement work?
kdpo -
11 May 2007 6:04 AM - 7 messages
Could someone tell where I can find out if it's true that during UPDFATE SQL Serve deletes data from table, and then inserts new one. Thanks -A ...
Restriction via join does NOT eliminate partitions ?
Ewen -
11 May 2007 3:57 AM - 2 messages
I saw in the following powerpoint [link] from the New England SQL Server User Group ( [link] ) the statement that restrictions applied via a join DO NOT eliminate partitions. ...
XML Bulk Load problems
dc -
11 May 2007 1:35 AM - 4 messages
The other forum public.sqlserver.xml is not as popular so hopefully I can get an answer. As a XML newbie (but have been a SQL DBA for many, many years) I am on a fast learning curve. I have a source XML in an EDIFACT d96A format. ...
Problem Registering Existing Server
Bob Bartel -
11 May 2007 12:43 AM - 6 messages
I am trying to reregister an existing server that we've been able to register previously. I can successfully register it inside the network, i.e., from another workstation on the network, but when I try to register via a gateway, i.e., ...
Profiler replay with more than one database
FredDBA -
10 May 2007 9:25 PM - 4 messages
Hi, in order to reproduce the production workload I am trying to use the replay trace functionality of the profiler v.2005. I did everything the doc says, same dbid, same logins/users/passes, use the traceSQL template, etc.. ...
Sqlsrvr.exe high memory usage
Brian -
10 May 2007 8:15 PM - 4 messages
Hello, We have an SBS2003 server running SQL (the version that comes with it). We're noticing that the sqlsrvr.exe process is using over 1GB of RAM. This is causing the server to under-perform. The server has 2GB of physical ...
Why do I need SQL Server?
cjcpa -
10 May 2007 7:28 PM - 4 messages
I am running Vista Business and MS Office Pro 2003 with Outlook Business Contact Manger. All of my work is performed on a laptop and there is no Server or Network connections so what impact will removing SQL Server 2005 ...
Restore Log looking for Log path...
anonymous -
10 May 2007 6:52 PM - 3 messages
I am having difficulty restoring a database (DB_1) with 2 datafiles and one log file, DB Structure is as following: Filegroup PRIMARY with file name 'fnm_data' with physical file name and location D:\db\file_1.mdf, Filegroup 'FG1' with file name 'fgnm1_data1' with physical file name and ...
performance implications of collation changes
Mike Kraley -
10 May 2007 6:40 PM - 3 messages
for the most part, my (sql server 2005) application prefers to be case insensitive, so my default database collation is case insensitive. However there are a few columns which I really want to be case-sensitive. Is there any significant performance impact to setting some columns to have a ...
Problem shrinking db on sql2K
Danny Wacker -
10 May 2007 6:21 PM - 3 messages
Hi all - Enterprise manager tells me that one of my databases has 30GB free - exact numbers are: current size - 30475.00 MB space used - 3.00 MB When I go into the "shrink database" screen, I tell it to shrink it down to ...
Copy SQL Server 2005 Express database to SQL Server 2000
Angus -
10 May 2007 5:43 PM - 3 messages
Hello I have a copy of a SQL Server 2005 Express database - the mdf and .ldf files. If I copy to my machine and in the Enterprise manager try to attach the files I get error 602 - and apparently you cannot do this as the ...
Error installing SQL Server Developer 2005
Mervin Williams -
10 May 2007 5:36 PM - 4 messages
I'm trying to install Microsoft SQL Server 2005 Developer Edition and each time I attempt to I get the error message: "Failed to install and configure assemblies C:\Program Files\Microsoft SQL Server\90\NotificationServices\9.0.242\Bin\microsoft.sqlserver.notificationservices.dll ...
3rd party backup/restore
Terri -
10 May 2007 4:59 PM - 7 messages
I'm looking for recommendations for 3rd party backup/restore software for SQL Server 2000. The software must be cluster aware. Ease and speed of recoverability are most important. I am not so concerned with compression ratio but rather the ...
to find access on a server
moharil -
10 May 2007 4:55 PM - 4 messages
How do we find out who all logins have sa access , server roles in an sql 2000/2005 server -SM ...
Performance gain
DXC -
10 May 2007 4:10 PM - 4 messages
How much of a performance gain I can get on 1.2 million rows insert via DTS package If I, - Drop 1 clustered and 2 non-clustered index on the table I am loading - 2-3 foreign keys referencing other tables ...
Reboot SQL Server 2000 server periodically ?
SQL Server newbie -
10 May 2007 3:10 PM - 3 messages
We currently reboot our Citrix and Application Server server/machines periodically Is it recommended to reboot the server/machine which hosts the SQL Server 2000 periodically ? If so how often ? Our servers/machines are Windows 2003 Thanks ...
Moving data from 2005 *back* to 2000?
Derrick -
10 May 2007 1:30 PM - 3 messages
Good morning! Can anyone suggest possibilities, after upgrading a database from 2000-2005, to move data back to 2000 in a DR type situation? We want to upgrade, but would really like a mechanism to rollback to sql2k in case "bad stuff" happens performance or data wise. (if data corruption ...
Sorting text as numeric
ThatsIT.net.au -
10 May 2007 1:17 PM - 11 messages
I have a table where the order numbers are actually text, where a query is made against the the order numbers I get the numbers in a sequence like this. 1,10,11,12,13,14,15,16,17,18,19,2,20 ...
AWE question (Geoff N. Hiten)
Alex -
10 May 2007 1:10 PM - 3 messages
Hello We have windows 2003 server (8GB) with SQL Server 2004(sp4) +one small application installed on it. We also have \3gb parameter in the boot.ini It is a cluster Active/Passive What would you recommenf to insttall a hotfix to Passive first and then ...
Sysobject Status in 2005
NCKestrel -
10 May 2007 12:16 PM - 3 messages
We have a program that pulls a list of tables from the SQL server. We recently upgraded the SQL 2000 server to SQL 2005, and it gets no responses to the request for the list of tables. It is pulling the list from ...
Stored procedure insert
Mirnes -
10 May 2007 11:10 AM - 4 messages
What is wrong with this stored procedure: ALTER PROCEDURE SPDodavanjeFirme @FirmaNaziv varchar (100), @FirmaAdresa varchar (100), @FirmaPtt varchar (10), @FirmaMjesto varchar (100), @FirmaTelefon varchar (50), ...
Problem getting SQL and SQL agent to start automatically
Fox1977 -
10 May 2007 9:37 AM - 3 messages
Hi folks, Can anyone help me out with this strange problem I'm having. I have a new server (Win 2003 standard) that is part of a domain and it is running SQL 2000. I have changed the services to run as a domain ...
new stored procedures created as type system instead of user
ginarunco -
10 May 2007 2:00 AM - 2 messages
I am running SQL 2000 SP4. When I create a new stored procedure it is being created as type system instead of user. How can I make it so every new sp I create is type user instead of system? Thanks in ...
sharepoint and sql server
Iter -
10 May 2007 1:24 AM - 2 messages
Hi Guys, I have a question related sharepoint server, what is relationship between sharepoint server and sql server? Because I often run into these two words together, I don't know why. Is there any specific configuration for sql server? Thanks. ...
Failure adding a new partition range to a partition function.
Bernard Sheppard -
9 May 2007 11:44 PM - 7 messages
Long Post (so you know what I've already tried). I'll start off with the definitions of existing objects, but in summary, I'm attempting to add a new range to a partition function, and expect this to be ...
Scheduling DTS Package in SQL 2005
Daniel -
9 May 2007 11:19 PM - 2 messages
We have an issue scheduling a DTS package we have created... We can run the package manually in SSIS with NO PROBLEMS.... but when we attempt to schedule the package we receive the following error: Date 5/9/2007 6:12:57 PM ...
passing parameters
Bob Yang -
9 May 2007 8:58 PM - 3 messages
I have query like the code below in the traditional database. Do yo think I can pass the OLAP parameters to the tranditional database and the traditional database pass back the result after running the query? Do you think it is possible to convert something like this code to the ...
how long does it take to create a database in 2005 ?
Hassan -
9 May 2007 8:50 PM - 2 messages
I thought database creation was pretty fast in SQL 2005 and there was no zero initialization I ran a create database to create one with an initial size of 25GB for data file and 25 GB of log file and it ran for 11 mins. ...
SQL 2000 and Concatenating
wreed -
9 May 2007 7:59 PM - 2 messages
I have a stored procedure that did this originally.... SELECT @ID = r.caller_id, @LOCKED = r.rec_locked FROM xxxxx as r WHERE r.assigned_loc = @location_id AND r.PT_resolution_code = 'OK' AND (r.DR_resolution_code = '' OR r.DR_resolution_code = 'CB') AND (r.callback is NULL OR r.callback < Convert(char(10),getdate() ...
Full Text Indexing
Shkedy -
9 May 2007 7:28 PM - 3 messages
Hi, I have a large table with millions and millions of records all related to web traffic. I am trying to match certain records based on a query string variable; say varname. If I use the like operator it is SELECT ... FROM PageView WHERE QueryString ...
SQL Server 2000 Ansi Null legacy procedures
thejamie -
9 May 2007 6:57 PM - 3 messages
If I am correct, compiling a procedure from the 2005 environment to a 2000 SQL Server will default to the SET ANSI NULLs to ON. When the code is run from 2005 without specifying the words SET ANSI_NULLS OFF, the procedure is ...
2005 SP2 - Install failed error 29537
Adr -
9 May 2007 6:57 PM - 4 messages
Hi, We installed SP2 on SQL 2005 base a week ago. Everything seems to work and no errors are being reported, but it failed as per the following summary. I did not stop any services prior to installing and rebooted after the ...
SQL Database Backup and Transaction Log Backup
Adam Clark -
9 May 2007 6:35 PM - 3 messages
When doing a full backup, is it best to backup the logs first or the database? thanks ...
Log Shipping from 2000 to 2005
Cgal -
9 May 2007 6:26 PM - 8 messages
Can log shipping be configured from a SQL Server 2000 database to a SQL Server 2005 database? I have read some posts on the Microsoft forums that indicate that it may be possible if a backup of the SQL Server 2000 database ...
I cannot transfer column DEFAULT values from old table to new table
placidite1 -
9 May 2007 5:49 PM - 4 messages
Hi all, SQL 2000 I am doing : SELECT * INTO NewTable FROM OldTable WHERE 1 =0 The NewTable has the same : column names, Data Type and Length BUT the column DEFAULT VALUES don't get transferred , I always have te reenter them manually. ...
database and log files do not grow automatically
Roger -
9 May 2007 4:32 PM - 9 messages
I have a database on SQL 2000 SP4 that is set via Enterprise Manager to grow the database and log files automatically. It doesn't happen, however. They run out of space and don't grow, even though there is plenty of physical disk ...
stored procedure question
Derek -
9 May 2007 3:29 PM - 2 messages
i want to move updates and deletes and inserts from my vb code to stored procedures. my question is.... is it better practice performance to create separate procedures for each action (one for inserts, one for deletes, and one for updates) or is it ok to combine ...
AWE Memory on SQL Server 2000(SP4)
Alex -
9 May 2007 2:52 PM - 3 messages
Hello everybody We have windows 2003 server (8GB) with SQL Server 2004(sp4) +one small application installed on it. We also have \3gb parameter in the boot.ini SQL Server is using 2,7 GB. Application is using three processes , that each one is about 50 MB . ...
SQL database log files
Reuben Rinquest -
9 May 2007 2:49 PM - 5 messages
Hi there, We are running a Windows 2000 Server with SQL 2000 (SP3a) and are running out of space. The problem is that the Database log files are rather large. Is there a way to safely shrink/defragment these so that more space can be ...
SQL Server 2000 Database options questions
SQL Server newbie -
9 May 2007 1:02 PM - 8 messages
Hi, I'm new at SQL Server 2000 and have a few questions on the database options. .. 1) If the Database has the option "Auto update stats" and "Auto create stats" enabled, I assume that the Maintenance Plan job "Update Stats used by ...
performance issue
brian -
9 May 2007 12:59 PM - 6 messages
We have an SP to pull appointment history, it was taking a long time for query response. I ran the profiler for a day, then DB Tuning Advisor and accepted the changes to index recommendations. the performance for SP was ...
Copy SQL Server Row - Repost
Jon -
9 May 2007 11:44 AM - 3 messages
Hello all, I've reposted this message as I didn't make it to clear what i'm trying to achive in an earlier post - my apologies. I need to write a procedure that will SELECT a row in a table and ...
running dcpromo on SQL machine to demote it to member server
Cary Shultz -
9 May 2007 11:09 AM - 3 messages
Good morning! I am not a SQL-person so please excuse the simple question. We have a client (inherited) who has SQL Server 2000 SP4 (I think!) running on a Windows Server 2003 Enterprise Version Domain Controller. Well, there ...
Random MS DTC problem
karenandlasse -
9 May 2007 9:52 AM - 2 messages
Hi, We have a very annoying random MS DTC problem in our Commerce Server 2007 setup. Our application consists of two web servers and a database server in a workgroup environment (I would rather have had AD domain but this is ...
Copy a row in SQL SERVER 2000
Jon -
9 May 2007 9:19 AM - 4 messages
Hello all, I'd like to INSERT a new row based upon a SELECT of an existing row, I've tried the below but there's a syntax error: INSERT INTO TableA VALUES (SELECT * FROM TableA WHERE TableA.PK = ...
which server to put sql 2005 standard edition
Jason Blake -
9 May 2007 8:31 AM - 2 messages
Im still a bit unsure which one of 2 servers to put sql2005 standard edition for use on our line2000 program. Can i have your opinions. Here are the software and hardware configs of the servers. Server 1 HP proliant ml350G3 ...
can we get the deleted data back in SQL 2000
Sakthi -
9 May 2007 5:51 AM - 6 messages
Hi im current using SQL 2000, data in three tables has got deleted on friday, in the mean time some data is also get added into that tables. after two days only i recognize the some data are deleted. No i need the deleted data and ...
how to know which filegroup a table is using with a SQL query
Benny -
9 May 2007 5:27 AM - 3 messages
there are several filegroups I want to know which filegroup a table is using with a SQL query (i think there may be a SYSTEM TABLE I can query to know it) ...
sql server 2007?
Vadim -
9 May 2007 4:11 AM - 4 messages
Hi, I heard from somebody that sql server 2007 is in works or even about to be released in some time and lots of changing coming in there and possible compatibility issues. Does anybody have any info or can point me to a page on MS web site, etc...? ...
Migrate SQL2005 from Standard to Enterprise edition
Johnny -
9 May 2007 2:26 AM - 2 messages
Has anyone tried to migrate SQL2005 from Standard (SP2) to Enterprise edition ? I have trouble with it. I loaded the SQL2005 Enterprise edition CD, it prompted the following message after a few step. "To change existing instance of SQL2005 to a different edition of SQL2005, ...
Substring Query Help
jimbly -
9 May 2007 2:19 AM - 3 messages
Hi, I need to write a query in T-SQL that will match to part of a string; example I have a text string which follows the following pattern yyyy_colour_description eg 1976_blue_somedesciptionhere 1985_yellow_somethingelsehereblue 1992_skybluepink_alsosomewords Obviously I can filter on the year using left() but can't find a way ...
Need help with error: FCB::RemoveAlternateStreams: Operating system error 6(The handle is invalid.)
Jeffrey Tarnoff -
9 May 2007 2:17 AM - 2 messages
I'm a "visitor" from MS SBS land, and am far from being proficient with with MS SQL. However, we have a few apps that depend on it, and I'm wondering if anyone can help me with a problem we're having. ...
xp_sqlagent_proxy_account
Clint Colefax -
9 May 2007 2:12 AM - 3 messages
Hi all, This one is driving me nuts. I have an sql 2000 server, that I am trying to set the agent proxy account on and am getting the following error "The system cannot find the path specified." I have found a couple of posts and articles around the place talking about ...
Grant Control Causes SQL Server Agent job to fail?
dba -
9 May 2007 12:09 AM - 3 messages
I have a SQL Agent job that applies permissions to a SQL Server 2005 database after it has been restored, it executes in management studio, it even parses when you click parse with the job step. Yet it fails every time unless I remove this: ...
Creating seperate databases for acquired companies - best practice
nwhitehead -
8 May 2007 10:28 PM - 2 messages
Hi All, Our company has just acquired another company and I am in the process of creating a database for the new company. The acquired company is in the same area of business & require the exact same data ...
SQL Standard Trail Software
Deon -
8 May 2007 9:01 PM - 2 messages
I want to test the trail standard version of sql 2005. How many users are allowed and how many processors will be supported? ...
SQL2K Inserts/Updates Timeout
hals_left -
8 May 2007 8:15 PM - 2 messages
Hi for the past couple of days about 9AM the asp pages timeout when running Inserts or Updates on the SQL server, but are fine with Selects. I tried to stop the SQL service but it diddnt respond to stopping, a ...
It's like MS hates us...
Maury Markowitz -
8 May 2007 7:34 PM - 7 messages
So all I'm trying to do is a JOIN against a text file. It's a simple CSV, nothing fancy. The only "oddity", one is shares with _every_ other file I have to work with, is that it has two header rows, one that has the filename ...
RAID setup.
Microsoft Newsgroups -
8 May 2007 5:05 PM - 2 messages
Hello. I would like to know the point of view of the experts at this forum. I have one IBM xSeries 236 Server with just one ServeRAID 7 controller and six internal hot swapable SCSI hard drives of 73.4 Gb each. ...
Most Used SP's
Billy -
8 May 2007 5:04 PM - 4 messages
Hi, What is the best way to pull of a report which details which sp's are used the most in a database? ...
How does a computer name change effect SQL Server 2000?
zellmer -
8 May 2007 4:45 PM - 2 messages
I have a server running Windows 2003 Standard, SP1. SQL Server 2000, SP4 is installed on this server. What effect will changing the server name have on SQL Server 2000? Thank you, Karri ...
Installing SQL 2005 onto a drive other than C:
Blasting Cap -
8 May 2007 4:06 PM - 7 messages
Our systems have a server set up that we're planning to put Sharepoint and SQL 2005 on. We've run into a problem installing SQL - trying to force it to the D drive (where we've got plenty of space), will not complete. It gives an ...
Transaction and Data Log growth
Corinne -
8 May 2007 3:58 PM - 2 messages
Good afternoon, Is there a way of finding out how often and when a data or log file growth is taking place? I know what the growth settings are but want to find out more about when it is taking place, possibly how long it took and how often it takes place. ...
UNPIVOT with a JOIN
Bishman -
8 May 2007 2:47 PM - 3 messages
Hi, I am using the UNPIVOT fuinction as helpfully pointed out by 'Alejandro Mesa' from this NG. I need to join the source table to a second table but cant get the syntax right. Could someone help please ? This (Below) code fails when the INNER JOIN clause is enetered but is ...
Transaction Log Maintenance plan
Rockn -
8 May 2007 2:39 PM - 10 messages
I have a maintenance plan set up to back up the transaction logs every hour and overwrite backups that are older than 1 day. The log backups are never overwritten with newer ones and the hard disk space eventually fills up. ...
Databases mirrong configuration question!
Hate_orphaned_users -
8 May 2007 2:23 PM - 4 messages
Hi all, i could not find the answer to this on the net so i asked it here. If i setup mirroring with standard config: 1 server with sql5000 server with 1 named instance (principal) 1 server with sql5000 server with 1 named instance (mirror) ...
Active/Active Cluster Installation Failed
alim -
8 May 2007 2:22 PM - 5 messages
Hi All, I am trying to install active/active two nodes cluster (Windows Server 2003/SQL Server 2000 – sp3). I had successfully install the first instance. But the name instance failed. “Error: The cluster resource failed to come ...
Audit and Error Log Tables
MattC -
8 May 2007 11:59 AM - 3 messages
I've seen it done before that tables that contain Audit logs and Error data are sometimes placed in a different database. As some apps log user actions in quite a bit of detail these tables can get quite big and make the database grow quite large. ...
Please Help!!! SQLServerAgent doen't work in SQL Server Express(20
Pola -
8 May 2007 10:51 AM - 9 messages
Hello, In our programm we scheduling backup using function of SQLServerAgent. This programm works good with MSDE(2000), but this programm doesn't work with SQL Server Express(2005). What replace SQLServerAgent functionality in the SQL Server Express(2005)? Please help, ...
SQL Server 2005 Functions in View not being optimized
Joerg Fischer -
8 May 2007 10:48 AM - 3 messages
Hi there, Currently, I am facing a problem concerning SQL Server 2005: Given a view for invoices, one row per invoice (header infos). This view calls a UDF (written in SQL) which accumulates data from the detail table of the invoices. ...
Inconsistencies in tempdb
LaurenceT -
8 May 2007 10:03 AM - 3 messages
Hi folks have been getting this error recently. We've swapped-out a disk which looked to be faulty but this hasn't done the trick so we think that it may not be a hardware issue but may be due to a problem in tempdb ...
Basic Table in SQL Server 2005
Sabir -
8 May 2007 7:48 AM - 5 messages
Could anyone please tell me how to create a new table in SQL Server 2005 using Enterprise Manager? Thanks. ...
Problem creating script for automating ALTER INDEX maintenance
Richard Tocci -
8 May 2007 7:44 AM - 6 messages
I'm new to SQL 2005, but have been working with SQL 2000 for quite some time. In studying for the SQL 2005 test 70-431, I'm working in Chapter 12 of the Self Study guide, working on managing index fragmentation. ...
Sql problems
SB -
8 May 2007 3:54 AM - 3 messages
I need some sql problems (mid to not too complex) to create a test set as research problems. Is there any resource? Thanks. ...
Sql problems
SB -
8 May 2007 3:49 AM - 2 messages
I need some sql problems (mid to not too complex) to create a test set of problems for research candidates. Is there any resource? Thanks. ...
SQL Server 2000 does not free up space inside database
Bharath -
8 May 2007 2:38 AM - 2 messages
Hi, I have a big table that has a clustered index. I have close to 200 Gb in the table. The application team contend that they deleted close to 50 GB worth of data where as in the db - the space has gone down only by 2 GB. I have done ...
SQL Server 2000 does not free up space inside database
Bharath -
8 May 2007 2:38 AM - 12 messages
Hi, I have a big table that has a clustered index. I have close to 200 Gb in the table. The application team contend that they deleted close to 50 GB worth of data where as in the db - the space has gone down only by 2 GB. I have done ...
|
|||||||||||||||||||||||