|
sql
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Microsoft SQL Server Administrationmicrosoft.public.sqlserver.server
.fmt
farshad -
18 Mar 2006 8:12 PM - 7 messages
Hi, How is it possible to create a .fmt file with the following informations if they are required? server1 database1 table1 Thanks ...
Problem with master DataBase
julianohorta via SQLMonster.com -
18 Mar 2006 7:05 PM - 2 messages
Hello, all! Last week I had a big problem in my DataBase Environment. My master DataBase became corrupted and I couldn't start my SQL SErver again. The problem was caused by NTFS Corruption in Drive C:\ on Windows 2003 Server. ...
Database disappeared from sysdatabases after running out of file space
Chris Weston -
18 Mar 2006 6:18 PM - 13 messages
Guys and gals, I'm in all sorts of trouble here. I've been nursing a server with very little free space for my sql databases while I get a new one built, and it's been pretty safe, until a power cut the other day caused ...
How do I Modify a Stored Procedure?
needin4mation -
18 Mar 2006 5:41 PM - 5 messages
I am using the sql server express manager and when I right click on stored procedure I have a modify option. I use this, make my changes, and hit save. But is always saves a separate .sql file and never ...
How can I transfer Data From Access?
needin4mation -
18 Mar 2006 5:22 PM - 5 messages
Hi, I have an Access 97 Database. I have Visual Studio 2005. Can I use VS 2005 To upload data from Access 97 to my SQL Server database? I tried the upsizing wizard for Access 97, but it just gives an error ...
SQL2005 x86-x64 performance comparison
Tom -
18 Mar 2006 3:17 PM - 4 messages
Did anyone tested and compare the performance of SQL2005 x86 and x64 edition? What the performance boost is in a real production environments not just what Microsoft demos and presentations show us. If you have a server with at least 8GB or more RAM (where x64 should kick ...
DBCC MEMORYSTATUS
doller -
18 Mar 2006 6:36 AM - 3 messages
Dear all, How can i execute DBCC MEMORYSTATUS command on Linked server or Remote Computer. I dont want to connect my Query Analyser to the server i want to get information. thanx Doller ...
DBCC FREEPROCCACHE
news.microsoft.com -
17 Mar 2006 11:42 PM - 3 messages
Hi all. SQL2K, Enterprise Edition. On a heavily loaded OLTP system, I have a stored procedure running tremendously quickly. Nice. Query Profiler mostly reports 0 or 16 msec. Then, for some reason, with the system under the same load, it all of a ...
.ds file extension on sql server
Rsapru -
17 Mar 2006 10:59 PM - 3 messages
HI, In one of my MS sql servers i have lots of *.ds file present. can anyone tell me what these files are ? and can i delete these files? Thanks ...
Backward Compatability in Yukon using backup devices?
Cqlboy -
17 Mar 2006 10:07 PM - 4 messages
My peers have informed me that I should no longer code my backup routine using a backup alias via sp_addumpdevice because it is 1) Provided only for backward compatability and 2) Will not be supported in the future. Should I not be using a backup alias for these reasons? Yukon provides the ...
64 bit ntwdblib.dll
MParenteau -
17 Mar 2006 9:38 PM - 2 messages
We are currently installing SQL Server 2005 on 32 bit platforms as well as EM64T platforms. In addition to accessing it via OLE DB and ODBC, we also still use the API Library which requires ntwdblib.dll. This is not included ...
database naming
Rich -
17 Mar 2006 9:14 PM - 4 messages
Hello Group, where does it talk about naming databases in the books online? I thought that a database name could not have a dash "-" in the name? Rich ...
2005 dts package question
Paul -
17 Mar 2006 8:45 PM - 7 messages
Hi I am working with the trial ms2005 SQL Server measurement studio. I could not find how to create and schedule a DTS package, guess this is done with Enterprise Manager with mssql2000. JUst wondering if someone could point me ...
system_function_schema
Daniel Jameson -
17 Mar 2006 8:22 PM - 5 messages
Hi, In SQL 2000 you can create a function in the master database with a "fn_" prefix and then change its owner to "system_function_schema" and it will then be available in all databases like an "sp_" stored procedure is. However, system_function_schema does not exist in SQL 2005's master ...
License Questions
Conan Kelly -
17 Mar 2006 6:54 PM - 5 messages
Hello all, Our small business is going to need SQL Server for a couple more people and we do want to try to be ligitimate, so I have a few questions about licensing. We have SQL Server 2000 Standard w/ 5 CAL's. ...
Working with a SAN for 2-4 TB database
Randy K -
17 Mar 2006 6:40 PM - 6 messages
My agency is configuring its first SAN, a IBM DS4000. None of our staff know the best way to configure it for use wtih SQL Server 2000. I haven't been able to find any white papers or SANS forums to bring ...
Database server layout
mamun_ah -
17 Mar 2006 5:57 PM - 2 messages
Hi All, Being small, we have only one database server that serves our need (SQL 2000 Enterprise Edition). We never had any replication or mirroring. Now we will be installing SQL 2005. I was asked to look into the best way of creating a good database ...
sp_who show multiple rows for same SPID/Some SPIDS block same SPID
Jeff Ericson -
17 Mar 2006 4:55 PM - 2 messages
In a new to me environment, I see 8 rows for a given SPID in sp_who. Some of those rows may show blocks and that value is the same as the SPID in question. The server is 2k, SP4 4 proc box with Hyperthreading. Why the ...
waittype=WRITELOG
Marek Wierzbicki -
17 Mar 2006 4:46 PM - 7 messages
Hi In my server (MSSQL 2000 sp4) very often I see long time of executing query with waittype=WRITELOG Recovery is set to SIMPLE and there is no autoShrink. Auto increment file size (log) is set to 10% What can be the reason of this problem? ...
annoying SQL Server error message
Dominic30 -
17 Mar 2006 3:47 PM - 4 messages
Hi, We have developped many applications, for a major customer, connected to the same SQL Server database. Those apps have been programmed in VB6 and VB.NET. The SQL Server is located on a dual-processor server, running Windows 2000 Server, with 3 gigs RAM. The apps are installed on ...
Data From SQL 2000 to SQL 6.5
John -
17 Mar 2006 3:40 PM - 2 messages
We're running production on an SQL 2000 server but still use and old 6.5 server for test purposes. Is there a way to copy data from a table on the 200 server to the same table on a 6.5 server? ...
TSQL help to delete
DXC -
17 Mar 2006 3:35 PM - 5 messages
I have 6 tables which 5 of them has foreign key to 1 table. t1, t2, t3, t4, t5, t6 where t2, t3, t4, t5, t6 have foreign keys referencing a column in t1 (version_number). How can I delete a record from all 6 in 1 TSQL statement starting from the ...
Using DBCC Shrinkfile on tempdb
MACason -
17 Mar 2006 2:41 PM - 2 messages
Just a quick question. Can DBCC Shrinkfile be used to shrink the tempdb and if so is there anything I should be aware of when using it on tempdb. We had a process that grew the tempdb to 77 GB. We think we have a handle on the ...
T- SQL and Reporting services 2005 books
Hush -
17 Mar 2006 1:57 PM - 2 messages
Hi I know a fair bit about SQL, but i have always avoided learning T-SQL and how to create Reporting Services reports. Now that SQL Reporting Services is fast becoming the "must have reporting tool", i would like to learn ...
Filegroups Properties
new_sql_dba -
17 Mar 2006 1:28 PM - 4 messages
Hello I am fairly new to sql server and need some help:- We have a database with several file groups e.g primarry, data1,data2,data3,index1,index2,index3 etc. Each file group has one file associated with this and they are on seperated disks. ...
Multiple jobs on one schedule
brin -
17 Mar 2006 11:08 AM - 5 messages
Hi I am wondering if it's possible to run multiple backup jobs from one shedule in SQL Server 2000, so all backups are triggered simultaneously at a given time. Having looked at the sysjobs and sysjobsschedules tables in msdb it seems ...
Migrating SQL server from NT4 Domain to Windows 2003 Active Directory
raghava -
17 Mar 2006 10:47 AM - 2 messages
I was testing migration of user & computer accounts to Windows 2003 AD using ADMT 2. Source Domain: 1 NT PDC 1 Member Server running SQL 2000(most of the users using ...
SQL 2000 on W2k fragmentation
Boxington Headmaker -
17 Mar 2006 9:16 AM - 10 messages
I'm running SQL 2000 fully service packed, on Windows 2000, also fully patched. The databases, log files and several Gb of backups are all stored on a compressed partition of a raid 5 array. The partition is showing severe ...
Switching off logging on varbinary column
Yaro -
17 Mar 2006 9:11 AM - 4 messages
Hi MS SQL 2005 I am familiar with another DB but in mssql I am rather newbe. In database we have table with varchar(max) column. Users save in this column documents, read them, sometimes change. I am looking for solution to switch off logging operation on this column ...
Performance: Primary Key = int/nvarchar/guid/...
Pieter -
17 Mar 2006 8:19 AM - 6 messages
Hi, Is there a difference in performance when the primary keys of the tables are: - int - int with Identity - nvarchar - uniqueidentifier ? And if yes: which? Thanks a lot in advance, Pieter ...
How do I get my local data in the database on the Internet?
needin4mation -
17 Mar 2006 7:56 AM - 5 messages
I am used to working in an Intranet where I have access to all the pieces, but now I am working with the Internet and am stuck. I receive various datafeeds in the form of a CSV file and need to get that data ...
finding out the last login
maxzsim via SQLMonster.com -
17 Mar 2006 7:49 AM - 4 messages
Hi , Is there any table in SQL that actually tracks when is the last login for a particular user ? appreciate ur advise tks & rdgs ...
Alternative to OpenXML
Shilpa -
17 Mar 2006 7:05 AM - 3 messages
Hi All, I want to pass XML and the data in the XML should be stored in the tables of the database. However, I do not want to use the OpenXML statement. Please let me know. Regards, Shilpa ...
Memory allocation in MS-SQL 2000 instances
dries -
17 Mar 2006 5:33 AM - 3 messages
Hi, From a previous sys-admin I inherited a a MS-SQL (2000) machine with 3 instances. It is a nice machine with 4 Gb of memory but the memory allocation is very weird: Instance A: 1400Mb Instance B: 1000Mb ...
Windows says SQL is installed, but it's not!
flipman619 -
17 Mar 2006 5:32 AM - 3 messages
I am attempting to Upgrade from SBS 2003 Standard to Premium. When i start the installer, it goes to a setup requirements widnow and gives me this error: "SQL Server 2003 needs SP3 for Windows 2003 Server compatability." I can not get past this to procede with the upgrade. I no longer have ...
adPromptAlways
Wallace -
17 Mar 2006 5:24 AM - 3 messages
Hai, Can anyone tell what is adPromptAlways and what is the purpose? ...
Why do Ado.net don't use execution plan that Query Analyzer
David Dong -
17 Mar 2006 1:45 AM - 4 messages
Hi All, I would be grateful if you can give me some directions. Thanks. Best Regards, David ...
Changing default value for a column
rk rider -
17 Mar 2006 12:45 AM - 2 messages
I have an existing database and I want to change it so that if no value is inserted into a column that it populates that column with a zero instead of a null value. How do I make this change? I suspect I need to change all the ...
Query suddenly becomes very slow
McGeeky -
16 Mar 2006 9:44 PM - 4 messages
Hi. This is a bit of an open ended question which I don't think there is a single answer to but I woud appreciate suggestions on though. For the last few months a stored procedure has been taking between 2-12 seconds to ...
Trusted Connection failing
jfission23 -
16 Mar 2006 9:18 PM - 5 messages
My VB.net app running on 6 local computers and failing on another two, and I am stumped. The message I receive the two failing computers is: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection. ...
OLAP weird!!!
samsam -
16 Mar 2006 9:08 PM - 3 messages
While working with OLAP we encountered weird results specially when working with "averages" over 3 or more dimensions including Time dimension. Is the order of dimensions creation in a cube affects the calculation order??? ...
Stop & Start SQL Server for using scm
qq -
16 Mar 2006 8:31 PM - 5 messages
Hi, All, I wrote a batch file including the following command to stop SQL server: C:\Program Files\Microsoft SQL Server\80\Tools\binn\scm –Action 6 –service mysqlserver When I use manually to run the batch file in Command Prompt, it works fine. ...
creating a login
mkiger -
16 Mar 2006 6:55 PM - 4 messages
Is there a way to create a login and password, or change a login's password in management studio (sql 2005) without using a sql script? Any wizard or dialog box? ...
deadlocked on lock
TLehtinen -
16 Mar 2006 5:20 PM - 2 messages
What can I do to prevent this type of error messages occuring? Theese errros are coming basicly from readonly database transaction. One part of our massageboard on IIS. What causes this erros to occur? There is quite a lot ...
Move 2000 to 2005
David -
16 Mar 2006 5:14 PM - 7 messages
I have a database in 2000 that I want to move to a 2005 server. What is best way to do that? Backup and Restore doesn't work. Thanks. David ...
Internal SQL Server error
Stanley -
16 Mar 2006 5:07 PM - 4 messages
Hi, i have searched for my problem within this newsgroup but no found no solution for it yet. I have this query which results in a "Internal SQL Server error". According to MSFT the latest SP should be installed. I did that but without ...
Stored procedures in master database SQL Server 200/2005
Mike -
16 Mar 2006 4:49 PM - 3 messages
Could someone please provide me with reasons why NOT to store user created stored procedures in the master database? Thank you. ...
expectations for SUM query on 50+ million rows
Jeff Turner -
16 Mar 2006 4:41 PM - 5 messages
what's a reasonable expectation for a query like this run against a table with 50+ million rows with SQL 2005 Standard: SELECT NAME, SUM(Tickets) as NumTickets FROM MYTABLE WHERE TicketDate BETWEEN @StartDate and @EndDate ...
Page coruption
_Stephen -
16 Mar 2006 4:40 PM - 3 messages
I am seeing errors in my db all of a sudden. Msg 823, Level 24, State 2, Line 3 I/O error (bad page ID) detected during read at offset 0x000001d9bec000 in file 'g:\mssql\data\ecash_prod_Data.mdf'. or in an index rebuild I see this. ...
how to crash/corrupt a Microsoft SQL 2005 Server?
zot -
16 Mar 2006 4:27 PM - 3 messages
hello everyone, I'm doing some big load testing on my SQL 2005 Server like adding/update/remove thousands of entries. I wonder what would cause my server to crash or data corruption? It seems to run fine on load ...
Management Studio Question....
Chris Marsh -
16 Mar 2006 3:38 PM - 5 messages
When using the 2005 Management Studio and connecting to a SQL 2000 Server what happens to the databases? Meaning, if I open the 2000 Database with the 2005 Management Studio does it automatically upgrade it to 2005? Are ...
URGENT: Backup to network drive with SQLServer 2005
Gaspar -
16 Mar 2006 3:38 PM - 4 messages
In SQL2000 I can backup to a mapped network drive (Z: for example) as it is listed in the backup window (C:, D:, ..... Z:). In SQL2005, drive Z: is not listed and If I try to force it by writing the ...
Migrating to SQL 2005
Robert R via SQLMonster.com -
16 Mar 2006 3:37 PM - 2 messages
I am interested in migrating from SQL 2000 to SQL 2005. Are there some recommended pointers, sites, or steps involved in the process that you could provide? ...
Overcoming orphans
Robert R via SQLMonster.com -
16 Mar 2006 3:32 PM - 2 messages
How do you restore master to a new database and not orphan users in the process? ...
Rename a SQL2005 Istance
Mauro Miotello -
16 Mar 2006 3:28 PM - 3 messages
I've installed a SQL2005 with named instance: SERVER\SQL2005 Because some software does'nt recognize this instance, i'd like to rename it to default instance. Is it possibile ? How ? Mauro ...
what kind of index to use in this situation.
guoqi zheng -
16 Mar 2006 2:26 PM - 3 messages
Dear sir, I have got a table of about 10 fields, there is a ID (INT, Primary key) field, but not automatically increased. I only use 5 out of 10 fields in the WHERE or join clause. What kind of index should I create? ...
SQL Server Integration Services
ipramod -
16 Mar 2006 1:39 PM - 3 messages
Hi, Does SSIS, an integration services available only for SQL 2005? Or it is available to SQL 2000 also? Let me know ASAP. Regards, Pramod ...
Add User to Log-Shipped Database
Toni -
16 Mar 2006 11:39 AM - 3 messages
I have a SQL 2000 Enterprise Edition sp4 production database that is log shipping to 2 servers (one for DR purposes and the other for reporting). On the reporting server, the database is in Read-Only mode. I need to ...
sqlserver 2005 express license
lorenz -
16 Mar 2006 11:09 AM - 5 messages
Hi, i would install sqlserver 2005 express into server with 4GB RAM and 2 or more CPU...any problems? Thanks a lot ...
IN clause with comma seperated values in select query
ykparmar -
16 Mar 2006 10:57 AM - 5 messages
i m passing one one variable with comma seperated integer values to IN clause of select query i.e. declare @con varchar(1000) set @con = '1,2,3' select * from tbl_QuarantineItemDetail WHERE ContainerNo in (@con ) ...
Deadlocks "again"
Hush -
16 Mar 2006 10:50 AM - 5 messages
Hi I am getting the same deadlock on our SQL 2K server but with different SPID Ids throughout the day. I know what tables and Index information from the KEY: information , and that is it performing an exclusive lock. What i cannot figure out is what ...
How to "Grant" a Trigger ???
Lilian Pigallio -
16 Mar 2006 10:23 AM - 8 messages
Hi all, I use SQL 2000 and I have a special user who can anlu execute a Stored Proc: grant execute on spw_ac_web_action to trwebgroup It's OK but this "spw_ac_web_action" update a table (it's OK) and i have a ...
Licensing by the month?
Marty Sage -
16 Mar 2006 3:44 AM - 2 messages
Hi all, I recently came across a client that tells me they have purchased Microsoft SQL Server 2000 licenses in a "pay-as-you-go-scheme". Apparently this is called a Subscriber Access License (SAL) instead of a CAL. ...
Move DB by backup/restore or SP_Detach?
HK -
16 Mar 2006 2:26 AM - 6 messages
Question: Which method should I use to do the simultaneous change from SQL 2000 to 2005, and the change from an old PC (server) to a new one? Current: SQL 2000 + Old Hardware ...
Table comparison
mecn -
16 Mar 2006 12:29 AM - 5 messages
Hi, There is any ways(utilities) that I could compare the data between tables(same structure). in sql 2k sp4. Thanks, ...
MSDE 2000 problems with linked server
Lloyd Harrison -
15 Mar 2006 9:25 PM - 2 messages
I have set up several servers with MSDE 2000 sp4, have created tables in these databases, can access, read, write data to the database through win sql and asp. I have set up a linked server to an oracle database and created a ...
"Timeout Expired" on large table change
The One We Call 'Dave' -
15 Mar 2006 8:05 PM - 4 messages
I have a table containing several hundred thousand rows. Once of the fields in the table is named EODFeedDate. The field is nullable. I've decided that I do NOT want that field to be nullable. I've unchecked the ...
Installing SQL Server 2005
Zig -
15 Mar 2006 6:25 PM - 2 messages
Hello. I have a DC with a member server. I attempted installation and repeatedly receive the warning regarding admin user rights. Since I can't get past this, I can't install. I tried everything under the sun: create a new ...
Q: Diagram in SQL Server
JIM.H. -
15 Mar 2006 5:55 PM - 2 messages
Hello, I was trying to use Diagram in SQL Server, it is good but it does not have any printing or option to export it to other environment such as Word. Is there any free tool I can use to create Diagrams of my database? ...
Deadlock problem with insert trigger
Gabe Moothart -
15 Mar 2006 5:07 PM - 6 messages
Hello, I'm experiencing a deadlock problem with Sql Server 2000. Basically, I have a windows app that polls a web-service every few seconds, and the web service logs that communication in a table. Since there's no reason ...
Supporting user-defined "columns" with eye to SQLRS
Stan Spotts -
15 Mar 2006 2:40 PM - 7 messages
I'm looking for a best practice for creating user-defined columns that allows for not-overly complicated methods for reporting. To show general requirements: a user or manager adds a few columns specific to his department, including "column" names. He then wants to create a report that ...
enable advanced performance - no UPS
Peter Hartlén -
15 Mar 2006 2:22 PM - 9 messages
Hi! I just enabled disk cache and advanced performance on our SQL-server machine's disks. The computer doesn't have any UPS, so I guess I could be in trouble if there is a power outage. But how serious is this? The machine is ...
Can you share SQL Server registration across different machines?
shub -
15 Mar 2006 2:03 PM - 3 messages
I have set up several sql server registartion in one of ours servers. On this server I have the Read/Store User Independent unchecked on the options screen in EM. Now from my computer in my EM option screen I ...
Primary key and identity fields information got lost by "Import Da
ulrich schumacher -
15 Mar 2006 10:21 AM - 2 messages
Hi all! I want to import data from Sql Server 2000 into Sql Server 2005. When i select "Import Data" in 2005 and import tables directly from the 2000 Data Source, the primary keys and the identity fields information is lost in ...
64bit SQL
stevanflores -
15 Mar 2006 9:23 AM - 8 messages
Hi, Can anyone confirm that the 64bit edition on SQL 2000 will only run on Itanium 64 bit machines & not Xeon 64 bit processors? Is there an Microsoft article on this? Regards Steve ...
NEWBIE QUESTION: Database Move to Alternate Server
Orbital -
15 Mar 2006 9:04 AM - 3 messages
Hi All, I'm transferring some SQL 2000 databases to an SQL 2000 server and am wondering if someone could advise on the correct transact command lines? I've had a look at MS articles 221465 and 304692, but I was hoping for a ...
trigger for Inserting question
Jason Huang -
15 Mar 2006 8:47 AM - 2 messages
Hi, In my SQL Server 2000, I want to create an Insert trigger. If inserting into TableA, then it will also insert into TableB. What will the solution be like? Thanks for help. Jason ...
Backup and View question
Jason Huang -
15 Mar 2006 8:32 AM - 3 messages
Hi, I export my DatabaseA into a brand new DatabaseB, using DTS Import/Export Wizard. I have some Views in the DatabaseA. However, those Views in DatabaseA became Tables in DatabaseB, not Views. But what I want is View, not Table. ...
DB_E_ERRORSINCOMMAND ( HRESULT = -2147217900 )
Prince -
15 Mar 2006 6:30 AM - 4 messages
Hai all, I am getting an DB_E_ERRORSINCOMMAND exception when I try to open a recordset or execute query in VC++. But when I run the same query in Query Analyzer, it is working fine. I am sure the connection string is ...
Help
TLehtinen -
15 Mar 2006 6:23 AM - 4 messages
Could my prblem be related to this? [link] We have one SQL-server and 2 separate iis server as cluster. I run netstat and found out that both IIS machines have nearly 2000 TIME-WAIT tcp session ...
problem with BCP
doller -
15 Mar 2006 4:49 AM - 7 messages
Dear all, I created a BCP file from SQL Server2000 with .BCP Extension. Now i am trying to load data in the SQL Server2005 Database table. First was getting the error of remote connection which i solved . Now i am getting this below error ...
Group by weekends
FJC -
15 Mar 2006 3:52 AM - 8 messages
Hi, Does anyone know how to group by weekends? ...
Idle Sql Agent consumes CPU
Randolph Neall -
15 Mar 2006 2:33 AM - 3 messages
The performance monitor on our Win 2003 server often shows CPU at 25%, due entirely to Sql Server Agent at a time when the agent shows no jobs running. We stop and restart the agent, and CPU consumption drops to zero. A day or ...
SSIS error
Danny -
15 Mar 2006 12:01 AM - 2 messages
When installing SQL 2005 Integration services Developer Edition on Windows XP Pro SP2, I get an MSMQ error that I ignor. After the setup completes, I try to start SSIS service and get the following: Microsoft SSIS Service failed to start. ...
Interface
Mervin Williams -
14 Mar 2006 11:51 PM - 2 messages
Does Sql Server have a DDE interface? If so, where can I find documentation? Thanks in advance, Mervin Williams ...
Enforcing naming conventions
Tim Greenwood -
14 Mar 2006 11:51 PM - 2 messages
We're trying to enforce some coding practices here and were taking the sledgehammer approach of putting a trigger on the sysobjects table that would raise an error when invalid names were submitted. Why is "sa" not allowed to add a trigger to that table ? ...
connect to sql express
Jassim Rahma -
14 Mar 2006 11:37 PM - 2 messages
hello, can anyone tell me how to connect to sql express on local using C# thanks... ...
SQL Express Connection Issues
Stoneyos -
14 Mar 2006 11:05 PM - 3 messages
I am having a problem connecting to a remote SQL Express server. I have SQL Express installed on 2 boxes and am trying to connect to one from the other and vice versa through the SSMSE 'Connect to Server' interface. I can browse ...
.BAK extension ??
Drazen Gemic -
14 Mar 2006 10:56 PM - 2 messages
Hi ! Usualy I do not use SQL server, but this time I have got some data to import. Data is on the CD, and it is named with extension .BAK. The organization I've got data from does not have true DBA at this moment, ...
SQL Monitoring tools...
fishoj -
14 Mar 2006 9:52 PM - 5 messages
Hello all, I have over 50+ SQL servers on my Data Center floor and was wondering if anyone was aware of a tool or product thta could be used to monitor SQL DB performance, growth and alert when there is a problem... ...
encrypting data in SQL table?
TJT -
14 Mar 2006 8:10 PM - 3 messages
Is there any way to encrypt sensitive information in a table? I'd like to save sensitive data in an encrypted form and then later retrieve it and decrypt it. Is this at all possible? Thanks in advance, Tom ...
Log Shipping
azimameer -
14 Mar 2006 7:51 PM - 2 messages
I found that , Log file was not being restored in standby server for the past 40 days. So i disabled all log shipping jobs which was running earlier. Last week I created a brandnew log shipping script with 2 jobs and ...
DB question
Bob Mosley -
14 Mar 2006 6:50 PM - 3 messages
I currently run a server with an 80GB C: drive and a 300GB D: drive. I'd like to move my DB from the 80 over to the 300 and repoint it. Is this possible? Any information would be greatly appreciated. Thanks. Bob ...
Updating records in one table from another
cbanks -
14 Mar 2006 6:45 PM - 2 messages
I receive a weekly download file with both new records and updated records. Using Bulk Insert I copy all the records into a table I created to hold these records. Next I do a INSERT INTO from that table ...
SysAdmin and ServerAdmin unable to start/stop or pause services
tideland -
14 Mar 2006 5:59 PM - 7 messages
Using mixed mode authentication (SQL 2000), I have a SQL account which has been granted all of the SQL roles, yet it is unable to stop and start or pause the database or SQL server agent. Isn't SQL server supposed to pass on control of these services via it's ...
Sql Server Resetting Ansi_Nulls Setting
DonH -
14 Mar 2006 5:40 PM - 3 messages
In trying to resolve an issue with nulls being treated diferent in sql server 2005 than prior version, I have change the settings when creating stored proc to specify SET ANSI_NULLS OFF. The problem that I have is that when I try to modify the stored proc, ...
Procedure to Stress Test
MC -
14 Mar 2006 5:30 PM - 3 messages
Could someone write for exact SQL statment to stress test my tempDB, or production.db? (assume physical location is E:\Data\tempdb.MDF) In order to test exact size of productionDB, should I copy the mdf file, rename, and attached as different database to do it? ...
Read only and access to specific databases
Greg -
14 Mar 2006 4:38 PM - 2 messages
Hello everyone, Please forgive me as I'm VERY new to SQL Server. I am (in a former and current life) a Oracle Certified Master DBA, however, I've been given a new project -- SQL Server 2005 to administrate. Although I'm going ...
NEW B - {WildPacket}
WILDPACKET -
14 Mar 2006 4:16 PM - 4 messages
New to SQL. Running SQL2000 on Win2000 Standard Sevrer. I have been asked to upgrade to Windows 2003 Server and latest version of SQL server too. Any articles on upgrading SQL2000? What kidn of impact will upgrading from Win2000 to Win2003 will have on ...
How much allocated space is actually used?
bing -
14 Mar 2006 3:51 PM - 6 messages
Hi, This is SQL 2000. 3G has been allocated to store data for a database. Restoring this database takes very long. Yeah, I know, even if only 5M is used, 3G has to be restored. So is there any way to tell how much allocated space is actually used by a ...
Flag -T1118, "Concurrency enhancements for the tempdb database", is it required with SQL 2000 and SP
Next »
|
|||||||||||||||||||||||