|
sql
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Microsoft SQL Server Administrationmicrosoft.public.sqlserver.server
Admin password
Uncle Ben -
14 May 2005 6:55 PM - 2 messages
After I changed my admin password in Windows, my SQL Server Service Manager (i.e. the Agent) no longer starts up. How do I fix this? ...
Slow fetches and network buffer size
andsm -
14 May 2005 4:31 PM - 3 messages
I have SP which returns about 4.5 kb of data. Network buffer siize parameter on SQL Server is 4 kb. Fetch time for the SP is ~100-200 ms. If call same SP from same computer where located SQL Server, total execution time is 30 ms. ...
Corrupted table
Andrew Chalk -
14 May 2005 3:38 PM - 9 messages
When I try and examine a table in one of my MS SQL Server 2000 databases I get the following error from Enterprise Manager: [Microsoft][ODBC..] I/O error (bad page ID) detected during read at offset 0X00000000038000 in file ...MDF ...
Upgrading a W2K3 server with SP4 beta applied
Chris Wood -
14 May 2005 3:26 PM - 3 messages
Hi, I have been reading the installation info. It goes to great lengths to explain about MDAC 2.8 SP1 and MSXML 3.0 SP7. From my understanding on a W2K3 server, without SP1, it will not update MDAC 2.8 to SP1. Would I be ...
SQL Server 2005 Beta2 or Newer
Joe K. -
14 May 2005 2:46 PM - 2 messages
I downloaded SQL Server 2005 Beta2 approximately 3 months ago but I reformat the hard disk to my test server. What is the link to the download site? Thanks. ...
how do I delete messages that I posted to this newsgroup?
hsifelbmur -
14 May 2005 11:21 AM - 2 messages
how do I delete messages that I posted to this newsgroup? ...
linked server problem with @@SERVERNAME
The Gekkster via SQLMonster.com -
14 May 2005 7:33 AM - 4 messages
Hey all, In a stored procedure that retrieves data from a linked server, I want to do a simple 'test' for availability before attempting to carry out the SP's tasks: The linked server is 'defined' as its IP. DECLARE @serverUP varchar(100) ...
connecting to SQL Server 2000
Ansari -
14 May 2005 7:19 AM - 2 messages
hi all; I have a SQL server ent. edition installed on windows 2003, I want to register another SQL server instance installed on windows xp, in my enterprise manager. When I try to do that i get the following error message. ...
Regarging the Blank Field in SQL Server
Himanshu -
14 May 2005 5:20 AM - 3 messages
hi all, can anybody tell me that how will i prevent to store the blank fields in any table. if i uncheck the allow null property of a field in a table then it only bloks null values. bit through application ehwn i store values from a ...
Not able to connect to SQL Server after removing it from network
Vikas -
13 May 2005 10:44 PM - 2 messages
I have my application that is running against MS SQL 2000 database (both on the same machine). If I unplug the network cable from that machine then my application is not able to connect to SQL Server. If I take my machine and ...
SQL 2000 Install Fails with "setup Initialization error access den
thomas kobal -
13 May 2005 9:38 PM - 4 messages
I tried a sql server install and get: "setup Initialization error - access denied" Source: E:\x86\setup\sqlspre.ini Target: C:\Docume~1\Admini~1.domain\locals~1\Temp\Setupsql.ini Now it looks as though it wants to use a faulty directory, is there a way to ...
Null fields (username, host, etc) returned in a trace!?!
Dom -
13 May 2005 7:05 PM - 4 messages
I would be really grateful if someone would help me with this as I'm really stumped... I've written a stored procedure to enable me to kick off traces from the SQL Agent and they run just fine - the problem is that some of the fields ...
SQL server 2000 domain change
mcunningham -
13 May 2005 7:01 PM - 2 messages
I want to change the domain my sql 2000 server belongs to. What do I need to do to ensure proper execution of this process? This server is not part of a cluster and all accounts are local. There are no links either. ...
How to read (SQL SERVER Mini Dump) MDMP files ?
Raju -
13 May 2005 6:17 PM - 2 messages
Can some one let me know if there is any tool to read the MDMP files? Regards, Raju ...
Nonpaged pool ? What is it ?
Hassan -
13 May 2005 6:01 PM - 6 messages
The server was unable to allocate from the system nonpaged pool because the pool was empty . We keep seeing the above errors and our server crashes. I am trying to understand the basics here as to what is the nonpaged pool ? ...
forcing string value in table
Paul -
13 May 2005 6:01 PM - 3 messages
Hi just wondering if there is a way to have a script that creates a table write in a desired string for the first table entry? I have an application that I am allowing the de-activation of a record. I ...
Tutorials in SQL Server 2005 Beta 3
Greg@food family -
13 May 2005 5:30 PM - 2 messages
I am following the Customer List DTS tutorial in SQLServer Beta 3 and it tells me to launch BI Develpment Studio, then select File, New, Project. It says make sure Business Intelligence Projects is highlighted, the select DTS template. After trying to fully install EVERYTHING from my source disks, the ...
Newbie: HELP takes too long for ALTER TABLE!
steve -
13 May 2005 5:19 PM - 4 messages
Hi, I have a table with 16 million lines. After reading about data types and importing it from Access i decided to change some things to save space and make the querries more efficient. I entered the following in SQL Query Analyzer: ...
Unknow user name or bad password.
ChrisR -
13 May 2005 4:45 PM - 5 messages
sql2k sp3 I am boggled here. This isn't the typical scenario that normally generates this message from what I can tell. I have all the necessary permissions from what I know. 2 boxes. 1. All SQL Services run in the same Domain Administrator accout for both ...
Transactional Replication betwn 2 SQL 2000 Srvs w/ diff servicepac
Doug F. -
13 May 2005 4:36 PM - 2 messages
I have a Production SQL 2000 server that is SQL 2000 SP2. We have another server that is a DEV server that is running SQL 2000 SP3a. I need to set up either transactional replication between the Production server (SP2) and the ...
Download SQL Server 7.0
Dílson_Fernandes -
13 May 2005 3:36 PM - 2 messages
Hi, I need download SQL Server 7.0 urgentily. I´m going to install SMS 2.0, and especified this necessitily installation SQL Server 7.0 before. Thanks. Dílson Fernandes ...
dbcc trace flag 1807 for network files
Mangesh Deshpande -
13 May 2005 3:32 PM - 2 messages
Hi I am using in sql server 2000 DBCC TRACEON ( 1807 ) to create datafiles over network just for testing. Now i have to do the same test on "SQLServer 7" and I ran the same script. But I keep getting error. ...
Printing Text in Query Results
Lisa Farina via SQLMonster.com -
13 May 2005 3:24 PM - 6 messages
Hello, How can I print text next to a query result set in Query Analyzer? I have the following results: Foodservice Revenues --------------------- $16,077,196,215.00 $30,244,812,996.00 $177,835,953,607.00 I need it to look like this: ...
Dropping all connections to a database
Doug F. -
13 May 2005 3:03 PM - 4 messages
Is there an easy command I can use within a sql script that will drop all connections to a database, without having to go the SEM and dropping them via Management/Current Activity/Process info? Thanks. DF ...
upgrade to SQL 2000 Enterprise edition from STD edition
Mangesh Deshpande -
13 May 2005 2:45 PM - 5 messages
Hi Please share any doc or procedure or views or cautions to do upgrade from SQL server 2000 STD edition to SQL server enterprise edition 2000. Tks Mangesh ...
Why, Why? is tempdb being written to so much that my write queue is 30+??
Joe Otero via SQLMonster.com -
13 May 2005 2:44 PM - 4 messages
I have a stored procedure that takes 3 parameters. They can be null and the the logic is basically : create procedure a @cola nvarchar.., @colb nvarchar.., @colc nvarchar.. select cola, colb, colc, cold (etc) from tablea inner join tableb (on primary key) ...
restore question on sql2000
Mangesh Deshpande -
13 May 2005 2:44 PM - 3 messages
Hi I have a 60 GB sql 2000 STD edition database backup. I take backup on a remote machine A where I can restore it. But I have to restore the same database on another machine B where it can ...
SQL Server Syntax Enable/Disable/Execute Jobs
Joe K. -
13 May 2005 2:42 PM - 2 messages
I would like to create a script that can you to disable, enable, and execute my job call "daily backup". Please help me with this task. Thank You ...
Enterprise SQL move to Standard
Paul Bergson -
13 May 2005 1:51 PM - 7 messages
Is it possible to follow the steps of moving ALL db's from an Enterprise SQL Server to a Standard SQL Server? We would like to just stop the SQL services and move the DB's across, rename the server to match the old server and start the new SQL server. ...
Monitor MemToLeave usage
Jan Ahlbeck -
13 May 2005 1:47 PM - 2 messages
Hi, I am interested in detecting possible memory leaks in extended store procedures. Is there a way to monitor MemToLeave usage ? setup: win2k advanced server sp4 (cluster) sql server 2000 advanced server sp3a AWE + PEA Total mem 7Gb Mem for sql server 6Gb ...
repair_rebuild and the transaction log
J Jetson -
13 May 2005 1:21 PM - 4 messages
We have a large-ish database (160GB) which grew to over 300GB last weekend when the maintenance job failed. Half of it is unused but I can't shrink it due to index errors and when I run checkdb it also reports index errors. I ...
Awaiting DTC Message: UOW<tranID> -SQL Server 7.0
govind.mane -
13 May 2005 12:26 PM - 2 messages
Question : Are there any enhancements availbale on SQL Server 7.0 regarding this problem ?? What is the solution ? ...
Display Tabular Form from DBCC SHOWCONTIG Command
Robert Lie -
13 May 2005 9:29 AM - 2 messages
Dear all, I want to display information resulted by DBCC SHOWCONTIG Command in tabular form like below: (Pages Scanned) (Extents Scanned) (Avg. Pages per Extent).. TABLE A TABLE B TABLE C .... Is it possible? ...
Move existing table to another file or filegroup
ales vojacek -
13 May 2005 9:12 AM - 5 messages
Hi, is it possible to move existing table to another file or filegroup? Thanks Ales ...
Cannot start MSSQL Server 7
Water Cooler v2 -
13 May 2005 9:07 AM - 2 messages
I am not able to start the MSSQL Server service on my system ever since I shifted my house and got a new network provider. Earlier, I was on the local cable hub, now my computer is on a DSL network. I don't know ...
replication error - agent is suspect
maxzsim -
13 May 2005 8:25 AM - 3 messages
Hi, I have set up a replication and it was doing the bulk copy from SrvA to SrvB when it says "The agent is suspect as there's no response for the last 10 mins" or something like that ? what could be the problem here ? ...
Domain administrator password change
David Pounds -
13 May 2005 8:01 AM - 3 messages
Hi folks. Sorry if this one's a bit basic, but I'm a SQL 2000 novice. I've just taken over responsability for some servers and I need to change the domain administrator password. I was wondering if changing this will have any adverse affects on SQL. ...
Rights to watch diagrams
Michael Andy Poulsen -
13 May 2005 7:21 AM - 3 messages
In an environment with database designers and developers we would like to give the developers the rights to watch the diagrams created by the database designers. We prefere giving the developers a minimum of rights on the databases and the server. ...
execure store procedure from Query Analizer
Isambella via SQLMonster.com -
13 May 2005 5:56 AM - 5 messages
Hi, I am trying to execute a store procedure from the query analyzer, but I get following error "Could not find stored procedure 'GetSubscriptions'", my store procedure has 3 parameters. I wrote the following statements to the Query Analizer: Declare @Par1 as int, @Par2 as varchar , @Par3 as varchar ...
Can Triggers Help Me out
Manish Sawjiani -
13 May 2005 5:24 AM - 3 messages
Dear Experts, I am storing the rates in pricelist table and these rates are used in several tables. Is is possible to create a trigger that will change rates in all the tables wherever i have used the moment someone changes the rates in pricelist? ...
sqlservr.exe using high I/O
RK73 -
13 May 2005 5:08 AM - 6 messages
Once in a while sqlservr.exe shows a very high I/O. In task manager I/O reads are at 64 Million and I/O writes are at 58 million and I/O Other is at 408 million. The performance monitor shows %Disk time and Avg Disk Queue Length ...
Major Performace problem
Joe -
13 May 2005 4:00 AM - 12 messages
My server slows way down after a couple of days. I'm running an application (directly on the server) which calls a stored procedure several thousand times. This procedure in turn calls another one 6 times. Using the Profiler I see a 4 second delay between calls of the outer (or first) SP. If I reboot ...
Calling Oracle Stored Proc from SqlServer
rslewis232 -
13 May 2005 1:46 AM - 2 messages
I am trying to call an Oracle stored procedure from SqlServer. I have tried both the MS and Oracle OLE DB Providers. I can select records from Oracle and I can insert records to Oracle. The stored proc call dies. ...
VPN - SQL Connection Time OUt
DLS -
12 May 2005 11:34 PM - 4 messages
I'm trying to add a SQL server to my enterprise manager on XP SP2 so I can work off-site. I have named pipes and TCPIP enabled, but do not have port 1433 open on my ISA server. I keep getting a timed-out message. What ...
sql 2005 download
Mangesh Deshpande -
12 May 2005 11:07 PM - 2 messages
Hi I want to test sql 2005. I do not have any membership with MSDN. How can I download and test sql2005? Tks Mangesh ...
Commenets on Running Citrix on SQL Server? Anyone doing this?
Roger -
12 May 2005 9:21 PM - 4 messages
Our work is currently looking at getting a dual processor machine with 4GB Ram to run SQL Server 2000 and as a Citrix server? Is this possible? What gotcha's should I be looking out for? Any comments appreciated... ...
stored procedure
gurvinder gill via SQLMonster.com -
12 May 2005 8:43 PM - 2 messages
Hi I want to create a stored procedure. I have 2 tables called orders and orderdetail.Now i want to move orders from these tables in to new tables called orders2 and orderdetail2.Perticularly those orders which r there more than 60 day(means ...
store procedure
gurvinder gill via SQLMonster.com -
12 May 2005 8:03 PM - 2 messages
Hi I want to create a stored procedure. I have 2 tables called orders and orderdetail.Now i want to move orders from these tables in to new tables called orders2 and orderdetail2.Perticularly those orders which r there more than 60 day(means ...
Errors when running DBCC CheckCatalog command
Sam -
12 May 2005 7:34 PM - 2 messages
One of my users reported an error when testing against one of our Development Servers, against a user databases. The error the application generated contained the following: Could not find row in sysindexes for database ID 9, object ID 1284406774, ...
open table
Ilann -
12 May 2005 6:35 PM - 4 messages
when I right ona table in the object browser in query analyzer it opens the selected table, in some tables I can edit the content in some, I can't, do you have any idea? Thanks Ilann ...
Combine 3 Queries into One
Lisa Farina via SQLMonster.com -
12 May 2005 6:34 PM - 4 messages
Hello, I have a large database that contains info about several types of business industries. There is a table called Co_Ind_Sales which contains industry sales that I need to sum up for 3 separate industries. There is an Industry_Id in the Co_Ind_Sales table. I am using the following SQL in ...
stupid optimizer tricks
JRStern -
12 May 2005 6:31 PM - 2 messages
Where I'm hanging out these days, they seem to like to put "valid" flags on records in all sorts of tables. So, if I want to search where lastname like 'St%' and firstname like 'S%', even if I have separate indexes on lastname and firstname, the ...
Database Maintenance Plan Grief
H Lee -
12 May 2005 5:08 PM - 4 messages
I've been setting up database maintenance plans for years, but lately, I've been stumped by this particular database maintenance plan. All it contains are full backup routines for 2 databases in Simple Recovery Mode in a named instance to write out to a local drive. Every aspect of the ...
StoredProc Help...
j c via SQLMonster.com -
12 May 2005 4:41 PM - 10 messages
Hi all, I am trying to create a StoredProc to return an OUTPUT value. This output is the difference between 2 datetime fields. I have had success with some other OUTPUT StoredProcs, but were very straight forward computations -- ...
Alert & Cache Hit Ratio
C TO -
12 May 2005 4:26 PM - 3 messages
Hello World, How can I set up an alert when the Cache Hit Ratio has averaged lower than 60% for the past n number of hours (with 5 seconds interval) ? We are using Cache Hit Ratio to determine if we need to add more RAM to the ...
The SQL element of Veritas BackupExec 9
Maurice -
12 May 2005 3:41 PM - 3 messages
I have several servers on which I use Veritas BackupExec 9.1 for tape back ups. When I run the MS Baseline Security Advisor it identifies SQL Server 2000 SP3 installed and recommends SP4. Now it is not a full-blown install of ...
synonyms in SQL server 2000
Mangesh Deshpande -
12 May 2005 3:22 PM - 4 messages
Hi I am using linked servers a lot in application. I want to create small meaningfull table name for all these tables. Is there a concept called synonym like in oracle to create small names for these? Example: select * from [sql3].master.dbo.xx; ...
Question on Hardware failover of the MS SQL Server 2000 DB
Mangesh Deshpande -
12 May 2005 3:18 PM - 2 messages
Hi We are planning to purchase powervault 220 S which provides us a clustering mode. We can see the hard drives from both the machines hooked up to the powervault. I want to achieve machine level failovermachine hooked to the powervault ...
Question on the evacuate of the datafile
Mangesh Deshpande -
12 May 2005 3:10 PM - 4 messages
Hi I am using sqlserver 2000. I want to evacuate and drop a datafile. It is around 10gb. My question is Is it a online operation? and is there a performance impact on the database druing this. Are the tables available for DML during the time of evacuation? ...
HOW CAN I LINK TWO SQL SERVER
Agnes -
12 May 2005 2:24 PM - 4 messages
I had connect another SQL server VIA VPN , the server name is IP e,g 123.123.123.123 I can read the data sucessfully, However, I want to insert some data from my local server. sp_addlinked server '123.123.123.123' ...
Hyperthreading: Negative impact on performance?
lovemyalpacas -
12 May 2005 2:08 PM - 5 messages
A former colleague recently notified me about some some 'benchmark' testing he'd conducted with SQL Server and Hyperthreading - with some interesting results. Basically the conclusion he reached was "HT gives performance increases some of the time but most of the time it really ...
XP_SENDMAIL as a scheduled job
Marcell -
12 May 2005 1:59 PM - 3 messages
Hi I'm having a problem using xp_sendmail as part of a scheduled job. The actual stored procedure is being called from within a DTS package. When the package is executed manually, everything works OK and the mail is sent. ...
Performance Monitor for Indexes
Joe K. -
12 May 2005 1:30 PM - 2 messages
I have a SQL Server 2000 database with numerous indexes. The database developers have reworked the indexes to increase database performance. This database has Windows 2003 as the operating system on this server. What are the performance monitor counters that I should add to my perfmon job ...
The server encountered a stack overflow during compile time.
steven.harris -
12 May 2005 1:28 PM - 6 messages
Hi, Can anyone help? Im trying to run a query and im getting an error. "the server encountered a stack overflow during compile time." The query is fairly large (300k) and in the form of; SELECT * FROM Drug WHERE ([DrugKey] = 1 AND Year = 1995) ...
Process 54 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION.
Plantador Ren via SQLMonster.com -
12 May 2005 1:17 PM - 4 messages
Hi I´m having this message when i execute this proc : spU_documentos_1 3, 4, '', 'Plano de Projeto', 'Este plano de projeto foi elaborado na fase 1 do projeto para cotação eletrônica.', '2005-03-04 09:10:38', 1.1, 1, 2, 12, ...
Database Maintenance plans log
fatp -
12 May 2005 12:15 PM - 3 messages
I receive every 30 min 5 event into my event viewer application log telling me something like this 18265 : Log backed up: Database: UserDatabases, creation date(time): 2003/05/31(08:14:32), first LSN: 27:167:1, last LSN: 27:167:1, number of dump ...
SQLServer:Locks(_Total)\Lock Requests/sec
SQLCatz -
12 May 2005 9:54 AM - 2 messages
For a certain performance related problem that we are examining, I captured the "SQLServer:Locks(_Total)\Lock Requests/sec" in PerfMon. Got very high values. Is it true that a large number of the requests will be for System related ...
byte manipulation for int
sandiyan -
12 May 2005 9:52 AM - 6 messages
I've got a column that is as type int(length=4). This column is getting changed to smallint. Obviously, some values in the column will not fit into smallint type. I've been told that as part of moving data over, I should ignore top two bytes and carry forward ...
Hiding instances on the n/w (Port 1434)
Pmcg -
12 May 2005 9:32 AM - 2 messages
Hi, I tried to hide an instance of MSSQL2000 SP3 on the n/w by first removing all the enabled protocols using the server network utility which worked fine, i then renabled the TCP/IP protocol and selected hide server which seemed to ...
SP4 reports queries blocking on themselves?
Jonathan Levine -
12 May 2005 8:30 AM - 30 messages
Greetings. I just installed SP4 yesterday. I've noticed that several heavy queries that worked fine in SP3a now have unusual behavior. The queries report that they are terminated as a deadlock victim; however, there aren't any DML operations running on the database at ...
Question...
Skc -
12 May 2005 7:50 AM - 6 messages
We are running SQL 2000 on a Dell PowerEdge server with an Internal Dell PowerVault LTO2 tape drive. We are using Brightstor ArcServe with BAOF and SQL Agent. We have a client who is to give us data.... The data is in a SQLServer 7.0 database. ...
Clustered/Non-clustered indexes column selection
Terence Leung -
12 May 2005 6:51 AM - 4 messages
From what I've read, clustered index is particularly good for returning a set of data, expecially if the result set requires a sort by on those columns. My company is running education services. Let's say our enrollment table ...
Bulk Insert Problem
Kitty -
12 May 2005 6:43 AM - 3 messages
I receive near about 50 text files every month each has near about 1lakh to 3 lakh rows. they come in various formats (few with , delimiters, few with field qualifiers, few with mix and match of both, and few files with fixed ...
SQL Server 2000 EE on Windows x64
Hans -
12 May 2005 6:28 AM - 3 messages
Hi all, I was wondering if anyone here has got any information on the advantages of running SQL Server 2000 EE on Windows 2003 x64 compared to Windos 2003 32 bit? Are the SQL Server memory limitiations the same as on 32 bit windows or can ...
MSDE (local machine) to process records downloaded from SQL Server 2000, upload when finished
L Mehl -
12 May 2005 5:22 AM - 3 messages
Hello -- If this question is more appropriate for another newsgroup, please tell me. Our application requires the following: - users planning travel or being at location without access to the server (SQLServer 2000) want to be able to review and/or process selected records ...
Database transfer
No One -
12 May 2005 2:17 AM - 8 messages
I needed to move some databases from one SQL server to another (SQL 2000 on both). I did this by doing a back up of the server on one, copy the file across and restore on the other. The data is there and so are the ...
Return a horizontal table for result
John -
12 May 2005 12:48 AM - 12 messages
Has any one had luck writing a query that returns a result as follows: CheckID Pay Amt Deduct Amt Tax Amt 1 Admin 200.00 401k 70.00 FUTA 13.00 ...
pLEASE HELP:URGENT please
nikila -
12 May 2005 12:41 AM - 4 messages
I am new to sql server . I have to write a trigger to insert the data into second table when there is any update in first table. Do I have to execute the trigger every time by some command or it automatically fires when first ...
sql server sp4
Ed -
11 May 2005 10:10 PM - 4 messages
Hi, Is it necessary to install Service Pack4 for SQL Server2000? Ed ...
dbcc completed messages
Koni Kogan -
11 May 2005 9:55 PM - 2 messages
How do you avoid them (from Qa and/or a VB program)? Thanks in advance! KOni. ...
Deleting extended stored procedures in master
Steve -
11 May 2005 9:35 PM - 4 messages
Hello Our Audit group is requiring us to delete many extended stored procedures in the master database. If you google something to that effect you will see the list all over the Net of the specific procedures that are recommended ...
System Log being filled quickly by this event
Lisa -
11 May 2005 8:18 PM - 2 messages
Recently in the last week the below error has been flooding the system event log. Does anyone know the fix for this? Event Type: Warning Event Source: MRxSmb Event Category: None ...
Good Data Modeling Book
Web Developer -
11 May 2005 8:14 PM - 5 messages
I'm looking for a data modeling book for one of the developers on my team. There are tons of them out there, so I'm hoping for a recommendation. Has anyone come across a book that does a particularly good job of teaching the ...
displaying database options
waltmallon@yahoo.com -
11 May 2005 6:04 PM - 4 messages
What tsql command can I use to display what database options are in affect? Such as ansi nulls, ansi warnings, etc. sp_dboption gives me a list, but doesn't tell me their values. Thanks, waltmal***@yahoo.com ...
comparing text fields - Second try
helpful sql -
11 May 2005 5:38 PM - 12 messages
Hi all, What is the fastest and best way to compare two text fields(data type TEXT). I just need to know when the values are different. Are there any functions available to do this? Please provide any code if you have it or any links regarding this ...
How to move Distributor to another server
Arsen V. -
11 May 2005 5:33 PM - 2 messages
Hello, I have 10 machines: 1 - publisher (on machine A) 1 - remote distributore (on machine B) 9 - pull subscribers (on machines C1 through C9) I got a new machine D. I would like to move the distributor from machine B to machine D without ...
Issue with restore to new dbname on same server
MarkAurit -
11 May 2005 5:31 PM - 2 messages
I ran this script to backup to restore a backup onto a database with a new name - on the same server. USE master ...
Single or Multiple instances
Data Cruncher -
11 May 2005 3:46 PM - 4 messages
We will be implementing an Active-Passive cluster server running SQL Server databases. The box will be a 8 CPU and 16GB ram and Sql Server will be Enterprise edition. There will be 4 databases plus Biztalk databases (10 in all). ...
SQL Server Install CD
Thefaz -
11 May 2005 3:20 PM - 3 messages
I have SQL Server 2000 sp2 cd and the SP4 exe. I can't get SQL to install in cluster mode on 2003 Enterprise since my install is SP2. Is there a way to upgrade the install files so that it ...
How to convert binary or hexa to decimal?
Adam -
11 May 2005 2:53 PM - 2 messages
Hello, I'm trying to decifer the data in the table that stores the data in the binary format. All numbers are placed in varbinary fields. All I know is the MS SQL 2000 database useing collation SQL_Latin1_General_CP1_CI_AS (default). For example the content of the field is: ...
SQL 2000 EE SP4 Memory Problem
Thomas Trageser -
11 May 2005 2:40 PM - 7 messages
Hello, my system is running on Windows2003 SP1 (german) and SQL 2000 EE SP4 (english). The server is an 4-way processor machine with 8GB RAM. The boot.ini is configured for /3GB /PAE. OS shows me the 8GB physical ...
what port my sql server is running on ??? 1433/UDB !!???
genc_ymeri -
11 May 2005 11:15 AM - 9 messages
Hi, We are a team of 4 developing a product which uses JBoss and sql server. While in everyone's else PC everything in working properly, but in my PC somehow we all can't figure out what port the sql server is running on. ...
SP4 install question
LL -
11 May 2005 10:51 AM - 4 messages
We have downloaded the SP4 files published on 6May 2005 and wish to know this: If we install SP4 and run into problems, can we uninstall SP4 to have it reverted back to SP3a? Also in SP4 there seems to be 3 parts: MSDE, ...
Determine first log backup after db backup
Wojtek Z -
11 May 2005 10:34 AM - 5 messages
Hello, How can I check if backup log fiile is first log backup after database backup ? f.e. I have 1 database backup file ( BACKUP DATABASE x TO DISK = ....) and 10 log backup files ( BACKUP LOG x TO DISK='....) ...
running sql server data marked suspect
Syed khurram alam -
11 May 2005 9:43 AM - 2 messages
hi all, I run application & database on same machine and suddenly my database marked suspect and data base is unavailable. I copy mdf file to other location and try to attached data but it show me error number 3624 any one help my I don't know why the database marked ...
Prompting connection str to access SQL server
maxzsim -
11 May 2005 6:14 AM - 4 messages
Hi , my connection string is as per follows but how can i made it such that i need not hard code the useid & pwd w/o having to create a user interface ? tks & rdgs ...
Primary filegroup
Gene Vangampelaere -
11 May 2005 6:10 AM - 4 messages
Hi I have a database with 3 datafiles : file1 => filegroup primary file2 => filegroup primary file3 => filegroup index_data Now I want to delete the file2. Is that possible ?? I get the message that the file is not empty. How can I determine what data is in the file ? ...
Replication in SQL
maxzsim -
11 May 2005 4:16 AM - 2 messages
Hi, I have 2 server A & B which A has been set up to push the data over to B However, i found that B's structure is not correct so i intend to backup A and retorse into B , will the replication to B fail after restoration from ...
User-Defined string Functions Transact-SQL
Igor2004 -
11 May 2005 4:06 AM - 3 messages
Ladies and Gentlemen, I would like to offer you the following string functions Transact-SQL GETWORDCOUNT() Counts the words in a string GETWORDNUM() Returns a specified word from a string AT() Returns the beginning numeric position of the first occurrence of a ...
Audit Logs in SQL SERVER ?
maxzsim -
11 May 2005 3:50 AM - 7 messages
Hi, Does SQL provide an Audit log on who is accessing which database and what's being done on each table that's kept in certain system tables or is there any stored procedures to keep track of this ? tks & rdgs ...
|
|||||||||||||||||||||||