|
sql
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Microsoft SQL Server Administrationmicrosoft.public.sqlserver.server
One data file per CPU.. Why ?
Hassan -
13 Jan 2007 9:36 PM - 3 messages
They say tempdb requires one data file per CPU. Why ? Also, why just tempdb ? Why not every user database to have the same requirement of one data file per CPU? Thanks ...
How can I find a read/write ration of an existing SQL Instance ?
Hassan -
13 Jan 2007 9:34 PM - 3 messages
How can I find the read-write ration of an existing production SQL Server ? I mean I could take a guess by asking the business owners,etc of what they expect within the application, but how do I know for certain? ...
Error after installing Project Server
melickas -
13 Jan 2007 1:12 PM - 2 messages
We have SQL Server 2000 running on Windows 2000 Server Advanced. We recently attempted to install MS Project Server and it "broke" our current SQL Server. We now have this error and cannnot run our SQL Server-based application: Your SQL Server installation is either corrupt or has been tampered ...
Modifying system tables in SQL Server 2005
Prasad -
13 Jan 2007 12:40 PM - 2 messages
Hi, I wanted to know if there is a way to modify the system tables in SQL Server 2005, and if yes a way to audit these actions. I tried selecting from the system tables (using a DAC connection), ...
how to view image data
neilsolent -
13 Jan 2007 11:36 AM - 4 messages
I have an image column in my table in my SQL 2000 database. I have inserted a row with binary data for the column. Is there a simple way I kind view the data with Enterprise Manager? This is so that I can check that my C++ code that inserted the data is ...
deterministic UDF causes reads on *some* servers
JXStern -
13 Jan 2007 5:11 AM - 4 messages
Have a big select, somewhat complex (does a pivot), that uses a few simple UDFs to format money fields into strings with commas, etc, something like: select f1 + dbo.myudf(f2) + f3 + dbo.myudf(f4) as myresult from whatever ...
SQL 2005 Installation Doc
Hassan -
13 Jan 2007 3:03 AM - 2 messages
Is there a link to "How to Install SQL 2005" doc that shows the different screen shots that one would see when doing a fresh install of SQL 2005. Thank you ...
Eliminate Multiple Joins to the Same Table in a Lookup Query
Lauren Quantrell -
13 Jan 2007 1:22 AM - 3 messages
I have a table holding primary data named DataTable intValuePK int PK intValue1 int intValue2 int intValue3 int strName varchar(25) ...
SQL 2005 - Moving master db
techgrl -
12 Jan 2007 9:26 PM - 2 messages
I am trying to move the master db (and I believe the resource db) to a different file location. BOL indicates that you should use configuration manager server instantance properites but there are no properties in configuration manager to change. Seems like something ...
database mirroring question
JoeyD -
12 Jan 2007 9:03 PM - 2 messages
Is Asynchronous database mirroring support in the Standard Edition of SQL 2005? I've read some docs that say it isn't. However, my manager saids that he was told it was (or would work), something about 'single stream'? I ...
log all queries
Tester -
12 Jan 2007 8:57 PM - 3 messages
Hi there, Is it possible in SQL 2000 to log all queries against a database? Thank you, Calin ...
DB Mirroring question
JoeyD -
12 Jan 2007 8:49 PM - 2 messages
I'd like to verify that the use Asynchronous database mirroring is NOT supported in the Standard Edition. I've read some docs that say it isn't. However, my manager saids that he was told it was (or would work), something about 'single stream'? I ...
Database Mirroring
JoeyD -
12 Jan 2007 8:44 PM - 2 messages
I'd like to verify that to use Asynchronous database mirroring is NOT support for Standard Edition. I've read some docs that say it isn't. However, my manager saids that he was told it was (or would work), something about 'single stream'? I ...
backups working but backup files are not being removed
childofthe1980s -
12 Jan 2007 8:26 PM - 3 messages
Hello: We have a SQL Server 2000 client who has a maintenance plan that does a full backup of course of its databases. And, each database is using the Full recovery model. The backup of the databases itself is working perfectly. But, the backup ...
Checkpoint and TempDB
cbrichards via SQLMonster.com -
12 Jan 2007 6:55 PM - 4 messages
We are running SQL 2005, SP1, on Windows 2003. Occasionally we have a TempDB log that starts growing exponentially. We run DBCC OpenTran across all databases, we look for high rowcounts on tempdb.. sysindexes for objects like '#%', but nothing shows its face. This happens ...
how to find index # and name in the same place
tootsuite -
12 Jan 2007 5:40 PM - 3 messages
Hi, I am wondering if anyone has a query handy for looking up the indexes for a given table, that would show both the index name *and* the index number in the output Thanks much ...
Bottleneck - Backup Server
Dave -
12 Jan 2007 4:49 PM - 2 messages
I am trying to analyze/identify the bottleneck on our new backup server. I was wondering if someone could recommend some performance counters to watch. Right now I am watching "% Write Time" I am averaging around "500" for this measure while copying a 50GB database file. It is ...
Is there such thing as "incremental" backup for SQL server?
ChanKaiShi -
12 Jan 2007 4:49 PM - 7 messages
I'm not looking for transaction log backups as substitute becouse it can still be larger then just changed data. My issue with differential backups is that they keep growing since last full backup and I want only changed data since last full or differential backup to ...
Copy database from SqlServer 2000 to 2005
David Thielen -
12 Jan 2007 4:46 PM - 5 messages
Hi; How can I copy a database from SqlServer 2000 to 2005? Copying between Sql Server 2000 instances we do a backup/restore but 2005 won't do a restore of a 2000 backup. ...
Table Refresh SQL 2007
Tim -
12 Jan 2007 3:56 PM - 3 messages
I have an application that is setup for a helpdesk incident reporting tool. Hhere are 3 columns dealing with the duration of an incident: DateCreated - datetime TodaysDate - datetime DaysOpen - numeric What I am trying to accomplish is to have the database conduct some sort of ...
Quick SQL Mail Question
jaylou -
12 Jan 2007 3:21 PM - 2 messages
Hi all, Here is a simple one. Can I setup SQL mail on a server where the SQL service and agent accounts are using the local system account? I think I need to set these services to a domain account, correct? ...
Integrity Checks continue to fail
Saral6978 -
12 Jan 2007 3:16 PM - 5 messages
I have a Maintenance plan schedule on one my dev databases, and I'm continually getting notices that it is failing. Here is the report that I get: Starting maintenance plan 'CRMDEV DB Maintenance Plan' on 1/11/2007 8:00:00 PM ...
2005 Copy database objects from one server to another
JerryWendell -
12 Jan 2007 3:10 PM - 2 messages
I just upgraded to SQLServer 2005 Standard. I do development in a database on one server. When a solution is completely tested, I move it to the operational database on a different server. With SQLServer 2000, I could ...
Log Shipping
Vick Shaw -
12 Jan 2007 2:12 PM - 2 messages
Can someone help me configure log shipping. The environment I'm working on is a 2Node Failover Cluster of sql2K. I couldn't get to configure it through the microsoft KB.. Your help is greatly appreciated. Thanks Beachcomber ...
UPDLOCK, HOLDLOCK combination hint
thejamie -
12 Jan 2007 1:53 PM - 4 messages
In Goran Rissler's question earlier today (Transaction deadlock on Tablelocks), a suggestion was made to use a locking hint combination. I do not understand how a locking hint combination works. Does it use the first hint first and apply the second hint when the first hint no longer applies? ...
Restore from SQL 2000 backup to 2005 locks user
thejamie -
12 Jan 2007 1:45 PM - 4 messages
Is it a bug that the login stops working when a database back'd up onto 2000 and restored to 2005 causes the SQL Authenticated login to stop working? Each night we restore the 2000 backup to 2005. Each morning the only method ...
Restore 8-CPU master to 4-CPU server. What will happen?
Oskar -
12 Jan 2007 11:48 AM - 2 messages
Hi, Restore 8-CPU master to 4-CPU server. What will happen? Can this be done at all? (MS SQL Server 2000 SP3 to SQL Server 2000 SP3 , Windows Server 2003 SP1 to Windows Server 2000 SP4). -- Many thanks, Oskar. ...
Transaction deadlock on tablelocks
Göran Rissler -
12 Jan 2007 11:44 AM - 6 messages
Hi, We are recieving a very odd deadlock problem while trying to implement a work queue. For some reason the server ends up in a deadlock when executing the same stored procedure from multiple connections. This only happens if a ...
SQL Server Licensing
kwiciak -
12 Jan 2007 11:11 AM - 2 messages
Question regarding Licensing SQL Server: I have server with 2 dual core processors and I would like to license per processor. What are the options for this scenario? How many licenses should I buy? TIA, Kamel ...
SQL 2005 x64 problem
Andris -
12 Jan 2007 10:28 AM - 2 messages
Hello! System: Windows 2003 server x64, MS SQL 2005 x64 I cant find soulution for my problem. About once in two weeks my SQL server remain weeery slow, and clear from ram DB. Used RAM jumps from 4gb to 700mb and server just do nothink, hdd and cpu is iddle. When ...
translating ERD to SQL Server tables
Waldo -
12 Jan 2007 9:03 AM - 3 messages
Hi I'm theaching databases and use SQL Server 2005 (developper edition) as DBMS. Now I'm looking for a free(!) tool that allows my students to create ERD's (Entity Relationship Diagrams) and that automaticaly translates those diagrams to SQL Server tables. ...
Database from 2000 Enterprise Edition to std
xiaomei -
12 Jan 2007 7:16 AM - 4 messages
Hi, There, I want move the database from 2000 Enterprise Edtion to 2000 Std, does Ms sql support that and any special way required? Thanks and regards Shermaine ...
How to modify a report in Crystal Report 7.0
microsoft . public . sqlserver -
12 Jan 2007 7:05 AM - 4 messages
I am a Web developer. I am new to VB 6.0 and Crystal Report. I have joined an organisation where there is an application running(developed in VB6 and crystal report 7). I have to modify one report. In two ...
Settings change that requires SQL 2005 restart
Hassan -
12 Jan 2007 4:26 AM - 2 messages
What are some of the sp_configure settings in 2005 that would require a SQL Server restart to take effect ? I have heard that a lot do not require a restart, but I want to know those that do. ...
Some basic OS fundamentals link
Hassan -
12 Jan 2007 4:24 AM - 2 messages
I know this may not be a SQL Server question, but I really want to gain some solid concepts on the foundation of the OS.. such as how the CPU , Memory and IO interact with the Kernel and each other.. What exactly is Virtual ...
SQL 2000 Profiler question.
Ankith -
12 Jan 2007 1:00 AM - 4 messages
Hi : I am monitoring the log file growth of tempdb on my production server and in the SQL Server 2000 profiler trace I am tracing the event Database : Log file Auto grow.The event says that the Log file Auto grow indicates that the log file grows automatically ...
Uninstall SQL Server Configuration Manager
Virtual Dave -
12 Jan 2007 12:41 AM - 5 messages
Hi, First the shaggy dog story: I am a student in a series of .NET classes. I have a seat of VB.NET Standard 2003, but decided to use the express versions for the first 3/4 of the class to get experience with the more current tools. Now that the class ...
table relationship help
Theresa -
11 Jan 2007 11:07 PM - 3 messages
Hello all, I am creating a copy of a database by using the backup/restore option. What I need to do with the new database (the copy) is strip some of the data out of the tables. However, we have hundreds and hundreds of tables that have ...
T-SQL Data Scrub Nightmare
maxvalery -
11 Jan 2007 10:51 PM - 9 messages
Hi, I have a table CUSTOMERS (structure immaterial) filled with customer information, about 200K records. The customer information includes firstname, lastname, address1, address2, city, state, zip, the usual. I need to send out letters to ALL customers in the table, and each ...
How to script index in 2005
Chris -
11 Jan 2007 9:07 PM - 3 messages
sql 2005 right click on table to script - create script does not include indexes, or perms. how to include? any help appreciated thanks chris ...
Importing CSV data into SQL database using DTS
Wildatom -
11 Jan 2007 8:55 PM - 2 messages
I would like to import CSV data into a SQL data base using DTS. This SQL database already contains the information however the CSV file contains updated information. data.csv Computer Name | Serial Number | Processors | Processor Description | Total Memory computer 168 123456789 4 Intel 3.06 Ghz ...
sp_executesql question
BillE -
11 Jan 2007 8:27 PM - 2 messages
My environment includes MSAccess 2000 adp/ade projects and SQL Server 2000 8.00.760 SP3 Enterprise Edition. In my profile trace, I often see the system stored procedure 'sp_procedure_params_rowset' executing an application stored procedure called by a report in the Access adp. ...
When will SP2 officially ship?
Rustom -
11 Jan 2007 7:23 PM - 2 messages
When will SP2 officially ship? ...
2 processors on a server
JJ -
11 Jan 2007 7:22 PM - 7 messages
I have a server that hosts sql server 2000 with 2 dual-core processors. I would like to have just one processor to handle sql server related processes since I only have one processor license. Do I restrict the usage ...
How to transfer backup from client to server machine (MSSQL, SQL Server)
Oz -
11 Jan 2007 7:10 PM - 2 messages
MSSQL, Microsoft SQL Server: I succeeded in transferring a backup file from the SQL Server machine to the client using OPENROWSET. I used this way because it is not (always easy) possible to restore a file residing on the client machine on a SQL Server. ...
syntax problem
d.s. -
11 Jan 2007 6:47 PM - 4 messages
Here's the code for a store proc I'm trying to call: set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go -- ============================================= -- Author: <Author,,Name> -- Create date: <Create Date,,> -- Description: <Description,,> ...
Connecting to a SQL Server 2005 over SSH using PuTTY
Trevor Murphy -
11 Jan 2007 6:45 PM - 5 messages
I'm having a problem connecting to my remote db from Management Studio, but I am able to create an ODBC connection from the Data Sources applet in the Control Panel. PuTTY is setup to convert localhost:21433 to 192.168.100.242:1433 (the ...
My SQL server doesn't exist?
Bryan L -
11 Jan 2007 5:53 PM - 2 messages
So here's what happened: I was running out of space on my DB partition (there was a sudden surge in DB size due to a lot of scanned documents being attached in a short period of time). To free up space for a day or two while I waited for an ...
prioritizing connection is SQL Server
steingold -
11 Jan 2007 5:23 PM - 11 messages
Hi all. Is there any API/ stored procedure that enable prioritization of SQL Server connections ? TIA Steingold ...
Replication Monitoring
DXC -
11 Jan 2007 4:58 PM - 3 messages
SQL Server 2000 EE. What is the best way to monitor replication and have it send an email to me as soon as it fails for some reason ? Is there a 3rd party utility for better monitoring ? Thanks. ...
Text output
tolcis -
11 Jan 2007 4:38 PM - 2 messages
I have a text string (1000 bytes) that is being generated via a store proc but I want it to be displayed with the new line character every 100 bytes. What is the fastest way to do that? Thank you, ...
SQL Server and Windows Performance Testing
Dragon -
11 Jan 2007 4:33 PM - 3 messages
Hi, Does anyone know what Memory and System performance should be set on a Windows 2003 server for SQL 2000 and SQL 2005? I am enquiring about the Advance Performance settings in the properties of My Computer. Thank you. ...
High availability, VMWare and remote sites.
Charles Deaton -
11 Jan 2007 4:17 PM - 9 messages
We are starting to look into a high availability solution to ensure operation of our business in the event of a localized disaster (i.e.. building fire). We are planning on a remote site, maybe 25 miles away, that will provide virtual servers and resources via ...
DB migration
Stefano Colombo -
11 Jan 2007 3:42 PM - 2 messages
I 've to migrate several DB between two SQL2000 servers . I'm planning to do it using the detach/attach method which I've been using successfully several times. This time , however , I need also to migrate DB maintanence plan, jobs , as ...
Install question
Ron -
11 Jan 2007 3:40 PM - 8 messages
I installed SQL2005 (Standard Edition - 32 bit) for the 1st time and it seemed to install fine. However, I wasn't prompted for licensing info (per processor or per seat) as SQL2000 does. Did I miss an option somewhere? The licensetype is ...
Date (SQL 2000)
stoney -
11 Jan 2007 3:25 PM - 3 messages
Hi, I get this csv file to import and the date in the column of the CSV file comes as 3/1/2007 0:00 When I import it to SQL with DTS it thinks 3 is the month but in fact 1 is ...
Mirrored databases and Witness server
KristinaDBA@gmail.com -
11 Jan 2007 2:32 PM - 5 messages
We are upgrading to 2005 and have decided to go to a mirrored 2005 environment. We have picked out the production server (principal) 16 gigs memory, dual proc quad core, Server 2003 Enterprise Edition. I am having difficulty finding out how "beefy" a box we need for the Witness ...
SQL 2000 and thesaurus
tolgay -
11 Jan 2007 2:08 PM - 4 messages
Hi, I use sql 2000 server and full text search. I would like to use fulltext thesaurus feature. Some how the thesaurus function does not work. What would be problem and how to solve it in SQL 2000 Server not SQL2005 we don't have ...
Monitor Autogrow
AF -
11 Jan 2007 1:20 PM - 7 messages
Is there a way to setup a job to monitor when an autogrow occurs? ...
Differential Backups Query - Multiple Restores
BB -
11 Jan 2007 12:04 PM - 3 messages
Hi There, maybe a very simple one here so apologies if it is. I was wondering that if I create a differential backup each day on one server, can I apply the backup each day to another server to bring it up to the same ...
How can I recover suspect Database , SQL 2005
Plamen Assenov -
11 Jan 2007 11:21 AM - 3 messages
Hi all I have e big problem , I have a database in SQL 2005 which is mark as suspect. I think the main reason for this is that someone have stopped tha database engine , while it has been working. Now the database is shown as ...
Performance issue
bsimon -
11 Jan 2007 10:26 AM - 6 messages
Hi group, I have a set of sql queries (around 20) that may execute randomly but periodicaly. What I mean is that I know each query will be executed at least once in a 3 minutes period but I can't predict the exact time of ...
Paging, Soring, Filtering Already-written SPs Result
Khafancoder -
11 Jan 2007 9:13 AM - 5 messages
Hi guys, we developed a large-scale web-application which uses sqlserver 2005, and we created all of SPs for geting list of particular records or geting a record info. i.e Products_GetList | Products_GetInfo & etc. now we need to implement paging,sorting or filtering on these SPs ...
SQL Agent ODBC Error
Shri.DBA -
11 Jan 2007 6:41 AM - 4 messages
Dear All, A sql agent job in one our sql server is failing with error message "Unable to connect to sql server". This error message is logged in SQLAgent job log file. During the failure I see the below error messages in the log file. ...
any link to capacity management for SQL Servers ?
Hassan -
11 Jan 2007 5:22 AM - 3 messages
This is not just tied to disk space, but also CPU load, IO, n/w throughput,etc.. Thank you. ...
SQL Server license issue
xiaomei -
11 Jan 2007 5:10 AM - 2 messages
Hi, There, I have a general question regarding the MS SQL server license, suppose I create one more instance on the SQL server, does it require one more same license as my existing one for this instance. Thanks and Best regards ...
Difference in Built-in accounts
Hassan -
11 Jan 2007 4:43 AM - 2 messages
For the SQL Server services, there are 3 different types of built-in accounts namely LocalSystem, LocalService and NetworkService. Can one tell me what the differences are ? Pros and cons of each.. Thanks ...
linked server error & tuning for OLE ODBC database
Chinnasamy Arumugam -
11 Jan 2007 3:28 AM - 2 messages
Hi, I have SQL 2005 connecting a ODBC database via linked servers. The issues are 2: 1. select * from linksever.db.owner.invoicedetail takes longer for the results to come. The table has 4,700,050 records. Is there any suggestion ...
SQL server 2005 install drive letter
Jenny -
11 Jan 2007 3:03 AM - 3 messages
We are having trouble installing SQL server 2005 to drive E:. Although we change the drive letter for the default installation directories it still installs most of the files, including the database directory, to C:, and installs virtually nothing to E: Any previous hint of SQL has been ...
Ping / Enumerate All SQL Servers In a Domain
c -
11 Jan 2007 12:18 AM - 4 messages
Here's a VBScript that pings/finds/enumerates all SQL Servers in a Domain. The script is basic and pops up server names and instances but not provide the SQL Version. If you'd like to add the output to a ...
Sql server user accounts
Max -
10 Jan 2007 10:25 PM - 6 messages
Hello, I have the SQL Server 2005 Workgroup edition and I'm trying to set up user accounts on it. I would like to use a database front end in MS Access to connect to the SQL Server back end. Some of the computers in the company have domain accounts and these can ...
Newbie question on dbo permission
Liming -
10 Jan 2007 10:05 PM - 3 messages
Hi all, I have a sql account in a shared hosting server and my account is able to execute scripts to create [dbo].* tables and [dbo].* store procedures. however, after they are created, if I tried to execute them, I get for ...
the differnce between SQL server express and the others
Bonzol -
10 Jan 2007 9:49 PM - 2 messages
Hey there,, just wondering if anyone could tell me the overall differences between SQL server express and all the other ones out there,, like enterprise and that. Are there any data restrictions, like if you have tones of data,, would SQL server 2005 enterprise handle it ...
execute a stored procedure from a DOS Prompt ??
WANNABE -
10 Jan 2007 9:45 PM - 4 messages
The SP is a simple Select of specific records, and I was wondering if this could be done through some SQL DOS utility ?? ...
text data is null in trace
byrd48 -
10 Jan 2007 9:31 PM - 3 messages
hi, I've done some searching and still need help. I created a trace on SQLServer and some of the longest running queries, some with several million reads, show TextData as null in the trace table. I have tried ...
Alter Database across linked server
cbrichards via SQLMonster.com -
10 Jan 2007 9:27 PM - 2 messages
We have approximately 30 servers with about 700 databases. We are running SQL Server 2005, SP1, on Windows 2003 We need to set Quoted Identifiers ON, as the default setting on all databases. Linked servers are set up on all servers. ...
Script wackiness
Earl -
10 Jan 2007 9:10 PM - 4 messages
I have tried to script all the tables and stored procedures from several SQL2005 dbs and I noticed that I get double-quotes for single quotes and a lot of extra single quotes near the END statements -- making the whole thing ...
Finding ancestors in a tree using CTE
sprash25 -
10 Jan 2007 8:34 PM - 4 messages
Hi All, I have a table thats organized as follows 5 EmployeeID BossID 8 3 9 3 ...
Auditing and IP addresses
PBsoft -
10 Jan 2007 8:22 PM - 2 messages
In a database I created an audit table in which, e.g., I insert one record for each INSERT statement made on another table (via a trigger). My problem is to recover remote IP address of the connected client which ...
Deleting a Log file and recreating it...
Saral6978 -
10 Jan 2007 7:13 PM - 7 messages
I have a 2GB database in SQL 2000 that has a 24GB log file; Not sure why this log file grew so much; originally the DB was set to SIMPLE so Trans logs weren't being backed up. This DB is in a Dev environment, so I think someone ...
Default paramenters in Functions
KristinaDBA@gmail.com -
10 Jan 2007 6:31 PM - 6 messages
Hi, Does anyone know if it is possible to use parameters in a function that are defaulted. For example, I have done this in a proc like this. Create proc Proc1 @param1 bit, @param2 bit = 0 AS ..... The user only really has to pass the first param and the second param ...
Transaction log file gets very big on weekends compared to daily
db -
10 Jan 2007 5:06 PM - 7 messages
Transaction log file becomes very big on the weekend. Backup is in full recovery mode and daily transaction log and full backups are taken. ...
SQL Server 2005 Require Reboot?
Joe K. -
10 Jan 2007 4:57 PM - 2 messages
Does SQL Server 2005 installation require reboot after the installation? I know Microsoft recommends to reboot the server after the installation. But is required for the program to function properly. Thank You, ...
Sql2k application activities
mecn -
10 Jan 2007 4:42 PM - 3 messages
hi, I have a db in sql 2k. I need to know what front end were connected. I don't see anything from current activities. There is anyway it could tell me what applications were connected? thanks ...
SQL Trace?
Thunder -
10 Jan 2007 4:20 PM - 2 messages
Hi all, I have not used trace in SQL Profiler before, or I should say, not for a very long time, on SQL 2000. Could someone help me do the following please? I want to see what/when/how/who changes a column in a table? ...
Export Column
H.Gjerde -
10 Jan 2007 4:04 PM - 3 messages
Hi How do I export column heading to a file? Or list them. BR Gjerde ...
sql 2k database does not have any free space
Michael Kurczewski -
10 Jan 2007 3:38 PM - 2 messages
I have a sql 2k sql server service pack 4 running on Windows 2000 server. I have many databases on the server but three of them show zero space available even though I have them set to automatically grow by 10%. I tried ...
Assertion errors? Error: 3624, Severity: 20, State: 1
Robert -
10 Jan 2007 3:38 PM - 2 messages
I've had a sudden rush of about 22 assertion errors come out in the SQL Server log, that stopped the active replication dead in it's tracks. Most of the other clients and processes seemed unaffected but I can't understand the ...
Backup Database remove inactive/replication
Gav -
10 Jan 2007 3:24 PM - 4 messages
Does doing a transaction log backup with 'Remove inactive entries from transaction log' option selected and shrinking database to free up space affect replication in anyway? Thanks Gav ...
Read CSV file - Save Columns into Rows
pintoo -
10 Jan 2007 3:09 PM - 2 messages
I want to import CSV file and convert columns into rows depending on Customer count(2nd record in each row of CSV file) and save to SQL table --CSV file format State, Customer_Count, Name_1, Total_1,Name_2, Total_2,Name_3, Total_3..can go upto 350 ...
password sql 2005
stoney -
10 Jan 2007 3:09 PM - 3 messages
I am creating an db login called test to test some sripts. When I try to set that password it says password validation failed. The password does not meet windows policy requirenments because it is too short. In sql 2005 is the password policy based on your windwows policy? ...
delete old files
mecn -
10 Jan 2007 2:59 PM - 4 messages
hi, I need to set up a sql job that deletes old files (Old than 2 days) in a dir. How do i do that? Thanks ...
permission over excute SP
WalidSQL2k5 -
10 Jan 2007 2:45 PM - 3 messages
Hi Friends, I want to create an DB_role with the target to give the excute SP permission to some users and when i create a new SP these users acquires the permission over the new SP. A lot of thanks for our possible help. ...
Restoring Database (With NoRecovery Option)
Restoring sql server2k5 db never finish -
10 Jan 2007 2:38 PM - 3 messages
When i try to restore a database (using sql server 2005) with NoRecovery option it continues to show me that is restoring and doesn't finish even after 2 days. any help please thank you ...
Copy table to a new database
msnews.microsoft.com -
10 Jan 2007 1:15 PM - 3 messages
Hi, I have a old DB "TrackOLD" and have instald a new "TrackNEW" I need som data in the "TrackOLD" DB How do I copy a table from "TrackOLD" to "TrackNEW"? Both DB are on the same server. Thanks ...
Restore Database
Alastair MacFarlane -
10 Jan 2007 1:06 PM - 4 messages
Dear All I am have trouble restoring a database from a device called 1.bak. When I try restoring the database it tells me that I need to be in single user mode. To do this I go to the command prompt and type: ...
No data file,damaged SQL Server,any chance to backup transaction l
Oskar -
10 Jan 2007 11:28 AM - 7 messages
Hi, No data file,damaged SQL Server,any chance to backup transaction log? (MS SQL Server 2000 SP3) -- Many thanks, Oskar. ...
Partitions / Filegroups
DBX1 -
10 Jan 2007 9:09 AM - 7 messages
Hi All, Has anyone managed to link the system views (or any other mechanisms) to display which partition number is in which filegroup? e.g. As follows: Table Name Partition_Number Filegroup_Name No_Rows Demo_Table 1 OLD_DATA 4,000,000 ...
dm_exec_query_stats/dm_exec_sql_text and plan cache
jeffbrewer -
10 Jan 2007 8:53 AM - 3 messages
We are using the following query: SELECT usecounts, size_in_bytes, cacheobjtype, objtype, REPLACE (REPLACE ([text], CHAR(13), ' '), CHAR(10), ' ') AS sql_text FROM sys.dm_exec_cached_plans AS p CROSS APPLY sys.dm_exec_sql_text (p.plan_handle) WHERE p.objtype = 'Adhoc' AND cacheobjtype = 'Compiled Plan' to figure out some of our worst offenders in terms of un-parameterized ...
Incremental Backup?
Leila -
10 Jan 2007 8:09 AM - 3 messages
Hi, I saw in description of RESTORE HEADERONLY that BackupType column can indicate an incremental backup! Is that different from Differential Backup or Log Backup? Is it new in SQL Server 2005? Thanks in advance, Leila ...
|
|||||||||||||||||||||||