|
sql
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Microsoft SQL Server Administrationmicrosoft.public.sqlserver.server
Halloween Problem
Leila -
1 Apr 2006 10:38 PM - 3 messages
Hi, According to this page: [link] Halloween problem occurs where the physical location of a row within a table changes due to a modification operation. As a result, the same row may be ...
SQL Server 2005 per-processor licensing: HT, dual-core?
n_o_s_p_a__m -
1 Apr 2006 8:28 PM - 2 messages
Hello, Can anyone state with certainty the per-processor licensing rules for SQL Server 2005 with regards to hyper-threading (virtual processors) and dual-core processors? Thanks -KJ ...
Error 5171 when attaching database
Bill -
1 Apr 2006 6:59 PM - 4 messages
I am having an issue attaching a database. I am getting Error 5171 - ls is not a primary database file. We did not have a backup of a database, so I am not able to restore a backup. The reason we do not have a backup of the database is a long story. ...
Disk Full of transactions log's
Richard@dt -
1 Apr 2006 11:59 AM - 3 messages
Hi, One of my app servers has filled the c:\ drive with transactions log's. Someone moved the log's to another disk, SQL now reports the database as being suspect. We moved the log's back, it still reports the db as suspect? ...
Multiple recordsets returned ..from one stored procedure ....
busyboy -
1 Apr 2006 4:21 AM - 2 messages
i have a stored procedure like this ... create proc mystoredproc as begin create table #temp1 (field1 numberic) insert into #temp1 select * from sometable if ( select count(*) from temp1 ) <= 20000 ) begin select 1 ...
sp_trace_setevent error
cbrichards via SQLMonster.com -
31 Mar 2006 11:51 PM - 3 messages
I am supplying the parameters for sp_trace_setevent dynamically. The string that I am storing the parameters in looks like the following: SET @sp = cast(@TraceID as varchar(10)) + ', ' + cast(@ev as varchar(10)) + ', ' + cast(@col as varchar(10)) + ', ' + cast(@on as varchar(10)) ...
Delete default database: login failed
sck10 -
31 Mar 2006 11:21 PM - 3 messages
Hello, I deleted a database and am now getting the error: cannot open user default database. login failed The database is on my machine using Windows Authentication. How do I change the default database, and what tools would I use to change it with? ...
SQL 2005 network access
Steve Z -
31 Mar 2006 10:40 PM - 4 messages
I'm trying to assist a customer - remotely yet - with a new install of SQL 2005. They built a new server - put Windows Server 2003 on it. They installed MS SQL 2005 - first time they did it they made in a "named" ...
The job failed?
nick -
31 Mar 2006 10:11 PM - 5 messages
I created a job on SQL 2005 - logged in using Windows domain user. And I get the following error message. Any clue to fix it? Message The job failed. Unable to determine if the owner (Domain1\nick) of job ...
Cancelling an indexing process
Saga -
31 Mar 2006 9:24 PM - 4 messages
This came up in a recent conversation. What happens if I reboot the computer while a reindexing process in underway? a. Acceptable b. Not a best practice c. Suicide Any feedback is greatly appreciated :-) Saga ...
SQL Server 2000 64 bit issues
DXC -
31 Mar 2006 8:58 PM - 3 messages
We have a Windows 2003 - 64 bit server where we want to install SQL Server 2000 EE 64 bit. I am getting the: "The image file D:\setup.exe is valid, but is for a machine type other than the current machine." error because the processors is AMD Opteron(TM) ...
Database Grow Problems
Bob -
31 Mar 2006 8:55 PM - 2 messages
I am having problems when I try to grow my database. It seems to be taken a long time (1 hour and still going) and is also making the system unresponsive. The CPU is at 0 but the computer is so slow nothing can be ...
Maintenance Plan 2005 invalid argument
nmsm -
31 Mar 2006 8:45 PM - 2 messages
trying to create an mp and i can't get past this failure (regardless of which steps and databases i select): "saving maintenance plan failed, one or more arguments are invalid." the plans all show up under jobs and i'm not able to delete them. ...
What is named pipe?
ad -
31 Mar 2006 8:07 PM - 3 messages
When I use Sql, I can choose between named pipe and TCP/IP. I never heard about named pipe before, what is it? ...
Am I missing something - DBCC SHRINKFILE('NewFile', EMPTYFILE)
Charlie -
31 Mar 2006 8:05 PM - 3 messages
I create a filegroup, added a file to it and created a table with 1 varchar(256) column to it. I then added several rows of data. I wanted to test removing the filegroup and can't. First I ran: ...
Stored Procedure that deletes and informs of success?
D. Shane Fowlkes -
31 Mar 2006 7:39 PM - 2 messages
Hello all. I have a SP (MS SQL 2000) that will delete select records from 3 unique tables. The SP works fine but is there a way to return some kind of value from the SP to know whether it worked or not? I'm using ASP.NET to call ...
OPENXML Question
Ganesh Muthuvelu -
31 Mar 2006 7:32 PM - 6 messages
Hello, This is my XML data: <RESPONSE> <FIELDS> <FIELD KEY="COLUMN1">a</FIELD> ...
URGENT: Can't see job history
helpful sql -
31 Mar 2006 7:27 PM - 6 messages
Hi all, I have scheduled a job to run everyday at 3am. But when I right click on the job and select "View Job History...", I get this message - "There is no history information for this job.". The Sql Server Agent service is running ...
Shrinking Files take extraordinary long time
Chris -
31 Mar 2006 6:38 PM - 3 messages
I have a database that it approx 20gb. The data file is 13gb, the index file is about 7gb and the trans file stays really low(not even worth mentioning). When I do a shrink database or shrink file from either the GUI or analyzer ...
restoring system databases
HK -
31 Mar 2006 6:06 PM - 5 messages
I've been testing a new 2005 server. After the install, I backed up the system databases. I've done a lot of junk testing stuff since then, and now I'm wondering if I should do a restore of the system databases before I ...
Threads and Transaction Problems....
pjondevelopment -
31 Mar 2006 6:05 PM - 2 messages
After four long hours of googling on the subject and finding almost nothing, I'm forced to post this one. I'm doing a small project that reads several IIS and stores in a database the domains hosted there. This application runs quite fine. But I'd like to add some transaction ...
SQL 2005 Enterprise and SQL Express on same machines?
manual tester -
31 Mar 2006 6:03 PM - 2 messages
I am working on virtual server 2005 and have installed SQL Server 2005 Enterprise edition and Visual studio 2005 on windows server 2003 SP1. During Visual Studio installation, there was an option to install SQL Express. I didnt select sql express since there was an instance of SQL ...
Another profiler question
Jude -
31 Mar 2006 5:10 PM - 3 messages
The first time I posted it landed under someone else's thread & I wasn't sure anyone would see it to help me out. I have a database that's being restored on a monthly basis, but I think this process is overkill. ...
Norwegian collation
David DB -
31 Mar 2006 4:51 PM - 6 messages
Hi, When I order by a field the sorting is wrong for Norwegian. The Å comes before the A for example. I have tried different collation settings of the database, but cannot find the correct one. Anyone ? Using SQL 2005/SQL 2000 ...
Profiler Question
Jude -
31 Mar 2006 4:50 PM - 3 messages
I have a database that's being restored on a monthly basis, but I think this process is overkill. The users are using a few tables or whatever to run reports using Crystal Reports, and accessing tables via MS Access. ...
changing authentication error, Please HELP!
Ilya -
31 Mar 2006 4:49 PM - 2 messages
I am running SQL Server 2005 Express. I am trying to change the server property to the mixed mode authentication (SQL Server and Windows authentication mode) in SQL Server Management Studio. I loged in to the server which is local in Managament Studio using windows authentication. When ...
SQL Server 2000 Std & Windows 2003 Server Std /3GB switch
freeman642 -
31 Mar 2006 4:12 PM - 2 messages
We have just bought new servers for separating out exchange server and SQL server. We have Windows 2003 Server Standard Edition with 4GB RAM, SQL Server 2000 Standard as I understand it uses only 2GB of memory. I was told ...
SQL TXN Log Files Size
John Williams -
31 Mar 2006 4:06 PM - 5 messages
If you have a 'full' recovery option for a user database. And the transaction log is set to autogrow...Does the file ever shrink by itself? I know the used portion goes down. But does the file size on the hard drive go down once it ...
Sql 2005 Service Broker - Process Isolation
Gidion -
31 Mar 2006 4:00 PM - 3 messages
Hi, we are looking into using Service Broker on a new project and have a question concerning the isolation of the service brokers applications. What would happen if one of the assemblies initiated by service broker (message arrived, so event-triggered activation) does something bad, ...
kill all processes
Wilfrid -
31 Mar 2006 2:45 PM - 2 messages
Hello I am looking for a command that would kill all sessions (active or not) on a database or server. Is there such command? thanks for your help Wilfrid ...
Lock Monitor
JI -
31 Mar 2006 2:11 PM - 2 messages
I have a sql server (Sql 2k Sp3) that has a very high CPU utilization count for the Lock Monitor. The database is used by a Java application that controls all update transactions. There are some instances where the app is ...
Estimating DabaBase space growth
julianohorta via SQLMonster.com -
31 Mar 2006 2:03 PM - 3 messages
Hello! All. I need to estimate a DataBase space growth, but I 've never had something like that. Anybody could help me wiht this? Which informations a need to make this estimative? Are there any rules or template to estimate it? ...
Tricky Stored Procedure Code
shaun -
31 Mar 2006 1:08 PM - 3 messages
Hi Ok here is a challenge to the group, I have a stored procedure that I use to create a report, its based on the following scenario A user calls in a raises a log in tblLog They are then sold stuff in tblSales ...
Error: 17883, Severity: 1, State: 0 during DB backup
Stacey -
31 Mar 2006 12:32 PM - 2 messages
I receive this error only when backing up database "a". I have changed times of day and ran it manually and it occurrs only on this one. THere are 15 other databases on the server. We are running SQL 2000 sp4 on Windows 2003 ...
how to clear up log file in primary database in log shipping ?
lovexueer -
31 Mar 2006 9:37 AM - 5 messages
our database system is runninig in log shipping mode. currently, primary database log file get much more bigger, but I dare not shrink log file in primary database , because do this will affect log shipping. any way reslove this? regards! ...
Performance Monitors on 64bit OS
Mike Duncan -
31 Mar 2006 8:31 AM - 3 messages
I am using a 3rd party tool to bind to the perf monitors, with no success. In the event log: Windows cannot open the 32-bit extensible counter DLL MSSQLSERVER in a 64-bit environment. Contact the file vendor to obtain a 64-bit version. ...
Reuse of space after truncating
Gurba -
31 Mar 2006 8:26 AM - 4 messages
Hi, Will space used by an table be unallocated if the table is truncated or will it only be marked as unused? TIA, ...
Database Recovery Model Default value
Usman -
31 Mar 2006 7:44 AM - 2 messages
Hi I've been using SQL Server 2000 for quite some time. Every new database I used to add, it would set the Database Recovery option to "Simple". Now after shifting to SQL Server 2005, this option is being set to "Full" by ...
Question of SQL
Kenneth -
31 Mar 2006 7:19 AM - 4 messages
Hello, I am new to SQL Server. I am writing a stored procedure with a sql like this SELECT sum(dbo.fn_Currency(Currency_Code, 'USD', ColumnA)) , sum(dbo.fn_Currency(Currency_Code, 'USD', ColumnB)) , ...
Repeated SubQuery
Adarsh -
31 Mar 2006 7:05 AM - 2 messages
Hi, Check this query: SELECT @ItemCodeID ,@ItemCategory ,LPD.LabelBatchContainerID ,LPD.ContainerNumber ...
Causes for SQL Server Stack Dump.
Ramesh -
31 Mar 2006 6:31 AM - 3 messages
Can anyone tell the general cause for sql server to generate an stack dump. And how important it is to analyze the dumps generated. Thanx ...
SQL Server Operation Guide
Praveen -
31 Mar 2006 6:02 AM - 3 messages
Hi All We are maintaining around 20 SQL servers in our organization. I want to know is there is any operational guide documents are available to maintain large number of SQL servers? ...
AS/400 DB2 TO SQL SERVER
ramkumar.nv -
31 Mar 2006 5:33 AM - 7 messages
I have created a database in AS/400 DB2 with 250 tables and 23GB data in the database, now I want to shift from DB2 to SQL Server. How can import the database from AS/400 DB2 to SQL Server, without ...
Linked Server error
kai -
31 Mar 2006 4:00 AM - 2 messages
Hi, All I have one default SQL Server 2005 "LIANG" and "LIANG\SQLEXPRESS". After I set up a linked server "LING" in "LIANG\SQLEXPRESS"., I try to run a query select * from LIANG.Northwind.dbo.Customers it gives me the following error: ...
Production vs. Test Environment, Linked Servers = Lots of Dynamic SQL!
bdtmike -
31 Mar 2006 3:57 AM - 10 messages
We have a SQL 2000 Database in both a production and test environment. There are numerous processes and procedures in this database that must communicate cross-server with another SQL 2000 database. This other server also has a corresponding production / test environment. ...
MSDE Release A
Huy (Andrew) V Nguyen -
31 Mar 2006 3:56 AM - 3 messages
Dear Experts, I heard that MSDE Release A removes the limitation of 7 concurrent queries that affect MSDE when too many users connecting to the system at the same time. Is this correct? Thank you very much ...
Linked Server VFPOLEDB gives Access Denied error
Ashley Brewerton -
31 Mar 2006 3:30 AM - 3 messages
When I login to the windows server as administrator, the query runs. When I login as anyone else (incl a user with as many admin rights as I can give him), I get the following error: Msg 7399, Level 16, State 1, Line 1 ...
SQL 2000 to SQL 2005 Compatibility mode - application role Issue
Kevinski -
31 Mar 2006 1:12 AM - 3 messages
We are currently run into an issue with upgrading our production db in the lab to SQL2005 compatibility mode 9. The upgrade process: 1. Detached and copied production db to our test SQL2005 server 2. Attached PROD_COPY_DB to sql2005 3. Ran the following script ...
Advice Needed
Code Boy -
31 Mar 2006 12:36 AM - 5 messages
I need to set up a table to define times when tasks will run. It needs to allow for multiple times per day and if the task should run on the weekends. Once the task has run once for the specified service window for that time of ...
drop the time
Johnfli -
31 Mar 2006 12:23 AM - 5 messages
I have a field in my table that is set as DATETIME The data that gets imported to it is a text file and has teh data with teh time. for example, 1/1/2006 4:57:12 PM I want to get rid of teh time part ...
New indexes not shipped to secondary server
mryan -
30 Mar 2006 11:34 PM - 3 messages
I am running SQL 2k on WinS2003 servers. We are using Log Shipping, leaving our secondary in a Read-Only state to be used for reporting. I have a need to get a new index on the secondary server (to decrease the ...
Service Pack of client
Rosie -
30 Mar 2006 10:56 PM - 4 messages
Hi, Do we only install service packs for the Server? Or we install them for client too. Is it possible that we have different service packs in Client and Server? if yes, how can I check what service pack do I have in client? ...
Server Fails to Restart
MikeV06 -
30 Mar 2006 10:15 PM - 4 messages
MS SQL 2000 Server instance 2 on Window 2003 with another instance used for backup installed. I stopped the server and tried to start it. It says it cannot start the service because the system cannot find the file specified. ...
2005 Licensing Question...
James Hunter Ross -
30 Mar 2006 10:09 PM - 3 messages
For our new single-cpu SQL Server 2005 database system, we have a pool of exactly 25 workstations that might need to access to the database. The DB connection will be through ODBC DSNs created on each workstation. There will NEVER be more than five of those workstations connected to the DB ...
dbcc memusage
renhai -
30 Mar 2006 9:52 PM - 5 messages
when I issued "dbcc memusage", I got the errors: Server: Msg 8966, Level 16, State 4, Line 1 Could not read and latch page (1:929) with latch type SH. VerifyPageId failed. but when I issued: "dbcc checkdb", it is working ok... ...
DTS Package Copy
Jim Heavey -
30 Mar 2006 9:27 PM - 2 messages
I want to copy the contents of one package into another package. I can bring up the 2 packages side by side and I can copy things like the Connection and the Text file, but I can't copy the transform between the 2 opjects....Is ...
delete triggers
mecn -
30 Mar 2006 8:38 PM - 3 messages
Hi,, How do i delete all triggers in one database? Quick way. Thanks ...
Stress Testing SQL Server Cluster
ATLDBA -
30 Mar 2006 7:56 PM - 2 messages
We are in the process of testing a new Veritas Cluster for SQL Service on iSCSI. I'm looking for a good tool, preferably free, to test the new cluster. Also, does anyone have any previous experience with such a ...
SQL 2005 Mirroring Question
TomT -
30 Mar 2006 7:38 PM - 2 messages
I have a client with an MS Access (2003) application, connected to a SQL Server 2005 database. There are a number of linked tables – via a dsn-less connection string, MDAC is 2.8. I am investigating the possibilities of using Database Mirroring (I know ...
help with Benchmark
Rick -
30 Mar 2006 6:31 PM - 3 messages
Hi guys!! does any one know a page at microsoft.com or another site that has the time sql 2005 takes to insert a row ?? i saw at microsfot.com some benchmarks but based on transactions and comparing Sql with Oracle and IBM, that's not what i'm looking for, i'm ...
Physical Server Name
JI -
30 Mar 2006 6:15 PM - 3 messages
I have SQL Server installed on a cluster. When I select @@servername it gives me the virtual server name, as does serverProperty('MachineName') or serverProperty('serverName'). When I select serverProperty('ComputerNamePhysicalNetBios') it returns null. How can I get the physical name? Actually it is a sql 2k box so that is why the ...
I/O issues after SP4 upgrade
Jake Marx -
30 Mar 2006 5:57 PM - 8 messages
Hi, We have upgraded 3 of our SQL Servers to SP4 in the past 2 weeks. We monitor these servers with Veritas, and we have noticed that all 3 servers have shown a marked increase (around 4x) in Disk Sec/Transfer, Disk ...
Pervassive Client Install
John Kamensky -
30 Mar 2006 5:39 PM - 2 messages
Would anyone install a Pervassive client application into the windows & sql 2005 cluster environment? ...
SQL Server 2005 Port Number (Named Instance)
Amos Soma -
30 Mar 2006 4:30 PM - 3 messages
We have SQL Server 2005 installed on a box with SQL 2000. When we installed SQL 2005 we created a named instance. I think when creating named instances port 1433 is not used. How can I determine what port SQL 2005 is using? I ...
%1 is not a valid WIN32 application
Reuben Rinquest -
30 Mar 2006 3:21 PM - 3 messages
We've recently installed SQL SP4 on one of our servers and are experiencing the following problem: SQLSERVERAGENT fails to start after the service pack has been installed with error: %1 is not a valid WIN32 application The system log reports pretty much the same error. ...
SQLSvr 2K SP4 Install
Rafal -
30 Mar 2006 3:18 PM - 3 messages
I'm running SQL server 2k on SBS 2003 and want to install CRM 3.0 however it insists I first install SP4 for SQL server 2k first. Having downloaded the file (SQL2000-KB884525--SP4-x86-ENU.EXE) and run it the wizard performs the ...
Sort sequence in SqlServer2005
SH -
30 Mar 2006 3:03 PM - 5 messages
I have a file that has a record in it with the ID [All] (including the "[" and "]" characters). When I do a sort on the file, this record comes out before the other alphanumeric IDs, even though the "[" character is ...
Email Resultset with sql mail?
Dan -
30 Mar 2006 1:39 PM - 2 messages
I would like to email myself the results of a query once a day. Can I do this with sql mail? If so, can someone point me in the direction of some documentation on how to do this? ...
Is it a good idea to use management studio to manage SQL 2000?
Maxwell2006 -
30 Mar 2006 1:38 PM - 4 messages
Thank you, Max ...
SOAP endpoints
Maxwell2006 -
30 Mar 2006 1:37 PM - 4 messages
Hi, I Can I create/configure/manage SOAP EndPoints through SQL 2005 management studio? Thank you, Max ...
ReIndex System Tables
Kevin Antel -
30 Mar 2006 12:55 PM - 3 messages
Is there a way to reindex system tables in SQL 2000 Server? ...
Cannot Generate SSPI Context
dominique -
30 Mar 2006 10:58 AM - 18 messages
hi @all, when rebooting the sbs 2k3 server, first the service sqlagent$sbsmonitoring failes to start and then the sqlserveragent. both events are record with the event id 103: sqlagent$sbsmonitoring: SQLServerAgent could not be started (reason: Unable to connect to server ...
Different execution plans from c# code and MSSQLServerManagementStudio
csaba.trucza -
30 Mar 2006 10:51 AM - 7 messages
Hi all, I've been looking into a strange problem in the last weeks. We use SQL Server 2005. We have some code written in C# which goes to the database, executes some stored procedures and retrieves the results. Now, the procedures are a little bit strange, as in a procedure we ...
simple query part 2
luna -
30 Mar 2006 9:20 AM - 7 messages
ok so im still stuck, i got it partly working - i needed an extra bit :( SELECT Personal.ID, Personal.surname1, Closed.Dateclosed, Closed.reasonforclosure, notes.notes, notes.dateentered FROM Personal LEFT OUTER JOIN ...
Connection to SQL Server 2005
Kahkashan -
30 Mar 2006 8:49 AM - 2 messages
Hi all, When I installed SPS 2003 , it installed MSDE as part of onstallation. I also installed WSS SP 2 and SPS SP2 on it. I have SQL Server 2005 also installed on my machine. How do I connect to this database for my WSS sites? How my sites in WSS ...
filegroups / reindex
Derk Jan -
30 Mar 2006 8:20 AM - 7 messages
Hi, We've installed a db with filegroups for data and indexes. Each filegroup has two equaly sized files spread over two diskdevices. When data is loaded it's spread equally over the files, if we do a reindex over all tables and look (via Tasks/Shrink/Files) at the file useage ...
Database backup size increases-no restore
ABB -
30 Mar 2006 6:29 AM - 2 messages
Posted in MSDE no reply!Urgent Our clients are using MSDE. Our VB application provides simple full backup feature usng DMO. We have noticed that their recent backup size goes to 2GB. to investigate, When backup taken from enterprise manager it is 60 MB. What ...
Newbie Help - Express exporting
Dajuroka -
30 Mar 2006 4:54 AM - 2 messages
I have been happily developing a site in Visual Express utilising SQL Express and then tried to copy to my ISP (GoDaddy). They provide a SQL Server database. After some mucking around I have worked out that my App Data folder ...
SQL 2005 Performance Issues, Help!
Bill Cohagan -
30 Mar 2006 4:20 AM - 4 messages
I've got a c# 2005 Windows app that is populating a couple of tables in a SQL 2005 database. One of the tables has around 5 columns and starts off empty. It eventually receives ~ 500,000 entries. My code does this via a ...
Full text indexing with Japanese characters problem
ibiza -
30 Mar 2006 3:56 AM - 6 messages
Hi all, I am quite experimented with SQL Server, but not that much with full text indexing. After some successful attempts with english fields, I've decided to try it with Japanese characters. I don't know why, but it ...
a good way to shrink log file when transactions running?
bluesky -
30 Mar 2006 3:32 AM - 3 messages
I am working in a large company where thousands new records will be added into sql server 2000. Our proudcts are running for 24X7. Transactions could be doing at anytime. So it is impossible to ask users to log off the system ...
sp_recompile
Brandon -
30 Mar 2006 12:33 AM - 3 messages
I have a stored procedure that is currently using a poor execution plan. SP_recompile marks the plan for recompile, but is not changing the plan after execution. Dropping and re-creating the stored procedure does modify the plan to use a much more effiecient plan. Any thoughts? ...
Can I delete a DB and add it back under same name?
HK -
30 Mar 2006 12:27 AM - 6 messages
Are there any "cleaning" issues I should know about if I delete a database in 2005, and then add it back under the same name with a newer .BAK file? I know how to delete, and how to import a backup, but I don't know if there ...
SQL Server Using ONLY virtual memory
Rob -
29 Mar 2006 11:31 PM - 4 messages
I have MS SQL 2000 SP3 on a Win2k3 box with 8 GB ram and 4 CPUs. The only thing running on this server is SQL, and no other processes are significant in size. PROBLEM: The SQL server is running only in virtual memory and will not ...
SQL 2005 SP1?
Joe D -
29 Mar 2006 10:37 PM - 3 messages
What is this "delivers new functionality for database mirroring"? Which isn't enabled by default on a new install. TIA ...
UNC path for backups
KMP -
29 Mar 2006 10:32 PM - 5 messages
I have a GUI (MS Access Application) which allows the user to choose the backup path (network or local) for the database (SQL Server 200 SP4). If it is a mapped drive, then that value (which is a "drive" not "UNC" path) gets ...
MSSQL 2000 Restore - can I roll back Transaction Logs
raekwon2112 -
29 Mar 2006 9:56 PM - 4 messages
Not sure if this is possible, but a client wants to now if we can use a backup we made on 2/24 and then pull transaction out of the database using the daily transaction log backups to get the database to be an effective copy of ...
Log File
Jim Heavey -
29 Mar 2006 8:28 PM - 2 messages
Ok, I am relatively new to SQL Server, so excuse my ignorance..... When does the data on the log file get flushed? I have this log file on my database which continues to grow and grow. I am really not interested in ...
sql 2k sp4 encrypt
mecn -
29 Mar 2006 8:23 PM - 4 messages
Anyone knows what it do I need to do tohave fully encrypt sql 2k sp 4 tables? Thanks ...
Recovering SQL login & database
Bradley Walker -
29 Mar 2006 8:10 PM - 6 messages
Hello all, I appologize in advance if I posted in too many, or the wrong newsgroup. A client of mine contacted me earlier regarding an issue they are having with their MS SQL server. They use SQL mostly for timeclock entry for ...
Rebuilding Indexes and Updating Statistics
Rick -
29 Mar 2006 8:07 PM - 3 messages
I believe that when you use DBCCReindex the statistics are updated for each table, but can anyone tell me if it does a fullscan update or a partial scan update when using DBCCReindex? ...
Anyone got a chart of datatype conversions?
HK -
29 Mar 2006 7:36 PM - 3 messages
I'm looking for a chart that shows the VB6 > .NET > SQL 2005 datatypes. E.g. VB6 .NET SQL2005 integer int16 smallint ...
Sorry for such a dumb question. How do I create a SQL2005 DB?
Vegemite -
29 Mar 2006 7:36 PM - 4 messages
G'day All, I have just installed SQL Server 2005 Developer Edition on my PC that also has SQL Server 2000 already installed on it. When I open the SQL Server Management Studio I see my PC Name with all the SQL 2000 DB's on ...
cannot connect 2005 using sa with ASP.NET
Les Caudle -
29 Mar 2006 7:31 PM - 4 messages
I un-installed SQL 2000 Developer's version - and installed SQL 2005 developer's version in mixed mode with the same sa password I'd used previously. I then attached all my previous databases. I can connect to SQL 2005 using the Management Studio using the sa user/pass. ...
Licensing question
Pierre-Nicolas -
29 Mar 2006 6:51 PM - 2 messages
Hi! We have a web site who connect to a SQL database (SQL server Eterprise) with a per processor licence. This SQL server connect to another SQL server (let's name it "SQL2") to query another DB. What kind of licensing should I use on ...
importing store procedures, How-to
Pritchie -
29 Mar 2006 6:01 PM - 5 messages
Hi, Can anyone tell me how I can import/export stored procedures in MS SQL 2005 from a different SQL server? Used to use the right click menu on a database (tasks, import/export) to do the job using DTS, and update all the SP and ...
DTS Simple Question
Jim Heavey -
29 Mar 2006 5:50 PM - 3 messages
I am just starting to learn DTS. If I set up in a DTS package a series of 5 independant processes, each of which Deletes rows out of it's respective table and then loads their respective flat file into those tables..... Will all of these run ...
Can Reporting Services use IIS on another server?
HK -
29 Mar 2006 5:45 PM - 5 messages
Reporting Services on SQL 2005 says that I must install IIS (its an installation prerequisite). Well, I really don't want to put IIS on a production SQL Server. I like IIS, but it certainly exposes a lot more ...
Is this use of shrinkfile safe?
fuiru2000 -
29 Mar 2006 5:41 PM - 5 messages
Hi all, I've been hunting around, but haven't found a satisfactory answer yet, so am hoping one of you can help me. On a production database on a SQL 2K server with Full recovery mode, we do a daily differential backup on the database. Then, weekly, we do ...
Large System Databases
shanghai360 -
29 Mar 2006 5:39 PM - 5 messages
I manage a SQL Server where the master database is almost 3 times larger than any other database and the tempdb is even bigger than that. I have not been monitoring the size of these databases for very long so I don't have a good baseline. However, it seems like a problem. I ...
|
|||||||||||||||||||||||