|
sql
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Microsoft SQL Server Administrationmicrosoft.public.sqlserver.server
Problem with LEFT JOIN
Matthias Kreusch -
27 May 2006 8:59 PM - 5 messages
I've tried LEFT JOIN and UNION but nothing worked as it should be. It would be nice if anybody has an idea what I could do. I have 2 Tables TABLE1 ID NAME 1 Anton 2 Bea ...
Moving Log Shipping Monitor
theSpinel -
27 May 2006 8:28 PM - 2 messages
Is it possible to move the log shipping monitor to a different server without having to re-create the log pairs? Hardware on our existing log shipping monitor server is failing and we need to bring it down, hopefully for good. We have another server to be used as the monitoring ...
SQL 2000 server takes 100% CPU Usage
brnayak26 -
27 May 2006 1:32 PM - 8 messages
Hi, My application is running on P4 3.2 xeon Dual processor, 2GB IBM Server. SQL Server 2000,SP3, Windows 2003. My problem is sometimes CPU Usage touches 98-99% and stays there for more than 5mins and whole operation becomes very very slow. Even though ...
Too many backup devices specified for backup or restore; Only 64 are allowed. RESTORE DATABASE is t
Jeremy Chapman -
27 May 2006 1:44 AM - 5 messages
On my developer machineI have SQL server 2005 express with a database configured as sql server 2000 compatability. I back the database up and copy it to a second server which is sql server 2000 personal. On that ...
SQL 2000 Log Shipping: Unable to select destination server
Kaman -
26 May 2006 11:36 PM - 3 messages
I am trying to set up log shipping for one of our SQL 2000 server, using the Wizard. In the Add Destination Database dialog, I can't select the server where I want the the database to ship to. I can see the instance from the ...
Drive lost - log files were on that drive - wondering about option
Steve Z -
26 May 2006 9:49 PM - 4 messages
I've got a customer who re-booted their SQL server (SQL 2000) and when it came up the F: drive - with all the log files - was gone. They are going to attempt to get the F: drive back on-line - hopefully long ...
DTS Package Not Running When Schedlued
Mitchm -
26 May 2006 8:47 PM - 3 messages
I have been having a problem where I can not get a scheduled DTS pachkage to run. It fails at all launch intervals. The Job can be launched manually and it will import the data just fine. I am trying to import foxpro files into ...
TRIGGERS over LINKEDSERVER
FredG -
26 May 2006 7:48 PM - 3 messages
Environment: Two SQL 2000 servers, sp3a SERVER 1: Windows 2k ADV SERVER 2: Windows 2k3 running on VMWare Server 1: Has a linked server to Server 2. Linked server security is set to use an remote id with system admin level rights. ...
Help Setting Up A Linked Server to Query Directory Services
Errol Neal -
26 May 2006 7:35 PM - 3 messages
I'm not sure what I'm doing wrong here but I've been banging my head against for a few hours now. Background: SQL 2000 on Windows 2000 Server SP4 as member server in an Active Directory Domain MSSQLSVR service and SQL Agent are running as a Domain Administrator ...
Migrate LogShipping Monitor
Fábio Jr -
26 May 2006 6:39 PM - 3 messages
Hi, I have a server SRV03 monitoring the logshipping between SRV01(Primary) and SRV02(Secondary), a need to move this role (monitoring server) to other server (SRV04). Is there a way to migrate monitoring server without need to reconstruct the ...
Windows Defrag?
RandyH -
26 May 2006 6:36 PM - 5 messages
Is it ok to run windows defrag with SQL Server 2005 installed? I have 3 logical drives. c - contains program files\MS SQL Server d - contains the log files e - contains the database files. Like Exchange Server you can't run windows defrag with the stores mounted ...
Replication - Replicating the contents from a view to a Table
Query Builder -
26 May 2006 6:36 PM - 3 messages
I have a complex query I use to populate reports. I need to move the reporting environment from actual production database that gets updated frequently. I have converted the reporting query into a view that pulls information from many tables with complex joins ...
UDF that returns a table: Running 'update' on it
moskie -
26 May 2006 6:28 PM - 2 messages
I have a UDF that returns a table defined as: RETURNS @Approvers table ( intApptID int, intUserID int, intIsHotButtonApprover_YN int, ...
Scripting
CLM -
26 May 2006 6:05 PM - 6 messages
I'm used to using Unix to do scripting. It's a pretty powerful scripting language with some looping, conditions, text editing/modification, etc. Does DOS have all that built in as well? Is that you guys use to script? If so, ...
SQL 2005 Upgrade
Kevin A -
26 May 2006 5:55 PM - 3 messages
Just curious if this is by design, but, when you upgrade over an instance of SQL 2000, by default, is it supposed to keep the databases in SQL 2000 mode, until we switch them to SQL 2005? My core belief is yes, it makes sense, just want confirmation. ...
Index tuning wizard
CLM -
26 May 2006 5:53 PM - 4 messages
I'm having trouble getting the above to do what I want. I pulled a trace table on a 2000 server. There were a couple of thousand of (mostly) stored proc runs pulled into it. I selected all tables but when it ran it failed ...
Trouble creating foreign key constraint
Tim Greenwood -
26 May 2006 5:03 PM - 4 messages
I have 5 tables that have no existing foreign key constraints at all. The main table at the top of the heirarchy is tblOrders. The other 4 tables are all immediate first level children of that table and all 5 are related by ...
Drop table statement didn't actually drop table...
apan -
26 May 2006 4:30 PM - 12 messages
I have a scheduled job that runs every minute to monitor for long-running jobs in production databases. This job has been running without issue for at least 8 months now. I have not done ANY work on ...
Large Transaction Logs
Brandon -
26 May 2006 4:27 PM - 5 messages
I have some databases that are keeping log files (.ldf) that are 3 times the size of the db and very large. What is the best way to shrink the size of these .ldf files? I have made backups of the db's and transaction logs ...
If Table Exist (ss2k5 and ss2k)
sck10 -
26 May 2006 3:58 PM - 3 messages
Hello, I have 4 different ways to test to see if a table exist. Is one preferred over the other for ss2k5? Also, except for the first example that used "sys.tables", which one is prefered for ss2k? ...
Error: 17883, The Scheduler 0 appears to be hung...
Scagnetti -
26 May 2006 3:35 PM - 3 messages
I've Googled myself silly on this and I'm not sure what I should do to fix it. Will SP4 do it? These errors happen every day at 8:00 PM yet there are no SQL Server Agent jobs running during that time. Any ideas? ...
Help - setup Sql Server 2000 on server on network
Sandy -
26 May 2006 2:56 PM - 3 messages
Hello - I have a VB6 application that is hooked up to a Sql Server database on my workstation computer. I will be distributing this application and have to install Sql Server 2000 on a server. I have never set up Sql Server on a ...
I'm Stumped! - (AS 2005 - Remote Connections Cannot be enabled)
BP -
26 May 2006 2:50 PM - 2 messages
Hello SQL pros - I am having a problem with enabling the remote connections for Analysis Services 2005, Here's the gist.... --Error Information-- "To configure Analysis Services for Remote Connections, you must be an adminsitrator for Analysis Services Windows Service (SQLSAC). ...
Backup using GZIP
PSPDBA -
26 May 2006 2:27 PM - 5 messages
I'm sure I'm not the only one in this situation: out of disk space on the backup drive, no other drives available, no money for new drives, no money for software. I'd really like to use LiteSpeed or SQLZIP, but no $$$ in the budget ...
Error 925 DB already open when i refresh current activity
alex sadykov -
26 May 2006 1:51 PM - 3 messages
I have 20 DB's on my server. When i set a DB1 to single_user and Run DBCC ShrinkDatabase command. Then start EM and refresh current activity I get an Error 925: Database DB1 already open and can only have one user at a time. ...
Removing Sql server 2005 user defined type
Congero -
26 May 2006 1:00 PM - 2 messages
I have a user defined type that i am trying to remove from my database. When i check it's dependencies, it references itself. I've removed the fields that used this type but I still can't drop it. Any help would be appreciated ...
Management tools SQL2005 and table ovner name dbo.tablename.
Geir Holme -
26 May 2006 12:46 PM - 3 messages
Hei all Using the new SQL Server2005 Management tools to view and edit tables/storedprosedures it automatically prefix the table and SP names with the ovner name. We usually type the first letters of the tablename to find the table name. Now we have to start with dbo.tablename every time. Is there ...
How To: Dynamic Crosstab Query Procedure for text values
mikecom -
26 May 2006 12:30 PM - 2 messages
Hi all Maybe somemone needs to know how to create a dynamic crosstab query without aggregate functions. The following sample is dynamic and can generate crosstab data in many variants. I could not figure out, how to insert a dynamic statement in the cursor ...
newbie: sql server problem
Jeff -
26 May 2006 12:03 PM - 6 messages
Hey I have a little network consisting of 2 computers (1 winXP computer and 1 windows server 2003 computer) I installed windows server 2003 a week ago... and now it works as domain controller in my little domain (set up because I want to learn more about ...
two select statements
7736 -
26 May 2006 11:36 AM - 5 messages
Good Day.. I am trying to run a query based on a previous sql query that is to run.. 'What I am to do is .. do a row count of a specific table on a certain Column. like Select count(name) ...
Slow response on Large amount of Data
newsgroup.com.hk -
26 May 2006 9:19 AM - 5 messages
Dear All, I am using SQL Server 2000 and i am facing performance problem recently. I have a table have around 200,000 records. When i select record from this table at the first time, it will take nearly one minute. But after the first ...
Index Views (materialized views) Actual mechanics behind inserting into
togbabe -
26 May 2006 7:36 AM - 5 messages
I would really like to know what exactly goes on when an insert or update is made in an 'indexed view.' I know that an indexed view is good for faster queries an slower updates and the basic reasons for ...
Trace Flag 208
John -
26 May 2006 3:50 AM - 3 messages
I have just found that I have trace flag 208 running on my MSSQL 2000 server, does anyone know what this does as I cannot find any info on Microsoft.com about it. I am additionally receiving : Error: 208, Severity: 16, State: 0 ...
Cumulative wait time on server replies
Kitty -
26 May 2006 3:29 AM - 2 messages
i've got 2 identiical db on 2 servers. the hardware config is different. i run the same queries on these 2 servers. execution plan, statistics like reads / writes / cpu time, etc are all the same, the only difference is the ...
I got 2 question, if tempdb is full, how to fix it? 2. if I have f
Iter -
26 May 2006 2:45 AM - 2 messages
I got 2 questions, if tempdb is full, how to fix it? 2. if I have full backup yesterday and no transaction log today and I delete data by accident, is there any way to recover it? Thanks. ...
Find the serial no from the computer
Eco -
26 May 2006 2:18 AM - 2 messages
I lose the original box of SQL server 2000 eng. How can I find the serial no. from the Server which installed SQL server 2000 before. Thanks much!! ...
table auditing
00KobeBrian -
26 May 2006 1:06 AM - 6 messages
I want to implement auditing information in the records in a table, say who has changed what at what date/time . This kind of information. Can you please tell me how and where the user stamp and time stamp I can get? ...
Open intial catalog?
Kevin Burton -
26 May 2006 12:33 AM - 3 messages
I have a connection string that has the clause "initial catalog=XXXXXX" in it. When I use SqlConnection.Open I get an exception that XXXXXX cannot be opened and the login failed. Any ideas? Thank you. Keivn ...
Starting Trace Flags 1204 and 1224
John -
25 May 2006 11:46 PM - 11 messages
Hi, I want to start the trace flags for 1204 and 1224 for tracing deadlocks, but I have forgotten how to do this so they report to the SQL Server Logs for review. ...
Re: DownDate ?? from SP4 to SP3
msnews.microsoft.com -
25 May 2006 11:02 PM - 2 messages
Sorry SUBJECT was backwards... Can it be done?? How can I UNDO my SQL2000 SP4 update and go back to SP3?? Does anybody know if that can be done?? ...
DownDate ?? from SP3 to SP4
msnews.microsoft.com -
25 May 2006 10:59 PM - 3 messages
Can it be done?? How can I UNDO my SQL2000 SP4 update and go back to SP3?? Does anybody know if that can be done?? ...
Behind the scenes SQL commands
supersonic_oasis -
25 May 2006 10:48 PM - 2 messages
Hello, I am running SQL 2000 SP4 on a Windows 2003 standard edition server. The SQL database gets changed/updated through a web interface. I was wondering if there was any way for me to see which SQL commands were being ...
restore
Andre Gibson -
25 May 2006 9:07 PM - 2 messages
hello all How do I get exclusive rights to the db. I tried to set it to offline but the db refused to let me while users are connected. Please advise Regards Andre ...
SQL Server 2005
anonimo -
25 May 2006 9:05 PM - 2 messages
Can I have installed SQL Server 2005 Express and Sql Server 2005 Developer Edition on the same machine? ...
"General network error. Check your network documentation." After Detach
escristian -
25 May 2006 8:34 PM - 4 messages
Hello. In our application we have to detach a database using a call from our C# application. The problem is that after that we get random "General Network Error" messages afterwards. This is all in a local call, both the application server and the SqlServer are on the same machine. ...
How to Encrypt a Backup File
Pancho -
25 May 2006 8:03 PM - 5 messages
Hello, I would like to password-protect or encrypt the .bak file for 3 selected databases on a MS SQL 2000 server. The DBs are all set for Full recovery mode and the nighly backups run OK now using a DB Maintenance Plan. ...
I need help developing a user registration/database/shop cart syst
Adam -
25 May 2006 7:56 PM - 2 messages
Hey everybody, Heres my predicament. I am the webmaster/designer of [link], a custom die-cast car company. We have a database of 20,000 clients who have all purchased from us before. Currently when we ...
sp_changedbowner
iamset -
25 May 2006 7:53 PM - 13 messages
A SQL 2000 DE version database has the login name "pest" and a user name of "dbo". I recreated the issue and tested this script below on my test server with SQL 2000 Standard Edition. The script fixes the problem, but does anyone know if SLQ DE reacts ...
Convert Clustered Index to Non-Clustered
jmelkerson -
25 May 2006 6:29 PM - 6 messages
How do I convert an SQL Server 2000 clustered index to non-clustered? Enterprise Manager would not let me. ...
I need Proof!!
burt_king -
25 May 2006 6:12 PM - 6 messages
Not the alcohol kind!! We're log shipping from one db to another in SQL 2000 and when I turn off log shipping and move to the new server I need to be able to prove that the two DB copies are identical bit for bit. ...
design issue: better speed performance by separating into different databases?
Zen -
25 May 2006 6:10 PM - 9 messages
Hi, From my limited knowledge, I think we can gain some speed performance by breaking up a database out into multiple groups of tables and create one database for each group - given that I don't care about the relationship as ...
Security issue in Sql 2005
Denis Desjardins -
25 May 2006 6:10 PM - 8 messages
I've got a field containing sensitive information and i would like to give the permission to place a where clause on this field without displaying this field, meaning removing the possibility of having this field in the select field list. ...
how does a query work
Dan D. -
25 May 2006 6:06 PM - 7 messages
Can anyone recommend a good book, article, whitepaper, etc. on how queries work? For instance, whether it's good to put a large table before a small table in a query, what the interaction is between an inner query (subquery) ...
Procedure for SQL Server (2000) When Changing Hostname
Arrwin -
25 May 2006 5:23 PM - 3 messages
Hi... We are changing the hostname of a Windows machine that we currently
have a SQL Server (2000) database on. What is the procedure that needs
to be performed in order for the SQL Server to recognize the new
hostname? ...
When did a stored procedure run last?
cloudina@hotmail.com -
25 May 2006 4:41 PM - 2 messages
Hello everyone - is there a way to find out when did a stored procedure ran last and who ran it? I have not used sql server in a long time and seem to have forgotten everything........ Thanks, Cloudina ...
Performance Problem on SQL Server 2000 SP 4 on Win2003
HG -
25 May 2006 3:57 PM - 2 messages
Hello, we migrate an application from old to new hardware. In this step we migrate also from SQL Server 2000 SP 2 on a Windows 2000 Server to SQL Server 2000 SP 4 on a Windows 2003 Server. Because of the new hardware almost every job ...
Table design question
Simon -
25 May 2006 3:43 PM - 6 messages
I have a table design question and related stored procedure question : I need to store default settings for a number of widgets. However, the data types for the settings vary (integer, string, floating point etc..). From a data normalization perspective it would seem the best course of action would ...
caching in ASP.NET
Samuel Shulman -
25 May 2006 3:07 PM - 3 messages
I noticed that although I deleted the entire table in the database, I continue getting the same results when I continue querying the database until the application is closed Why and how can I change that? Thank you, Samuel Shulman ...
Big Database
Rafael Tejera -
25 May 2006 2:56 PM - 2 messages
I need Help! My dabase has aproximately 45 GB and in the last weeks MSSQL started to consume all the resources, basically all the RAM of the server. My server has 8 GB of RAM. It keep consuming more and more ram memory without release ...
Escape the '\' character
Samuel Shulman -
25 May 2006 2:25 PM - 7 messages
I noticed that the following character needs escaping with another \ but only if it is not followed by another character What is the rule Are there any other character with that need escaping except ' (single quote) and wildcard characters when used with LIKE ...
Multi-Instance SQL Enterprise setup
Joe Spears -
25 May 2006 2:08 PM - 3 messages
Hi We have a SQL Server 2000 Enterprise server, with 4 named instances. One of the DB's which runs on one of the instances, requires the Service pack level to be updated (as stipulated by the DB application vendor). ...
How to convert MSDB from SP3 to SP4
msnews.microsoft.com -
25 May 2006 1:58 PM - 6 messages
Is it possible to take the MSDB database bakup file from a SQL2000 SP3 server and convert it to SP4 so it can be restored to an SP4 server, without updating the SP3 server to SP4?? ...
Incremental updation
Nicol -
25 May 2006 1:55 PM - 3 messages
Could anyone tell how to write a query to get incremental data from a database table. eg. first i will, write one sql stmt to get all the data from the datatable. After that, i need only the updated rows from the table. ...
Escpae characters
Samuel Shulman -
25 May 2006 12:15 PM - 4 messages
Hi I am looking for a reference that lists all special characters in SQL Server that must be escaped and how Thank you Samuel Shulman ...
Query Timout
Peter Longstaff -
25 May 2006 11:10 AM - 3 messages
Hi All, I am fairly new to SQLServer, although I have used other RDBMS software extensively. Is there a simple way to restrict the amount of time a query runs for? I have inherited a system that allows users to run very large queries and ...
When I backup my msdb database, it will also backup all DTS package ?
kelvinweb -
25 May 2006 4:25 AM - 5 messages
Dear All, All DTS packages stored in msdb database, right ? That's mean when I backup msdb database, it will also backup all DTS packages and no need to rebuild the DTS again in case of server down. I can restore backup ...
SQLSERVERAGENT ERROR 1075: The dependancy service does not exist..
Mark Sinclair -
25 May 2006 3:32 AM - 3 messages
Could not start the SQLSERVERAGENT service on Local Computer, Error 1075: The dependency service does not exist or has been marked for deletion. Our SQL Server has been running fine ever since, on Tuesday night we did a clean shutdown and added another CPU which made the box into a dual processor ...
Log Shipping Failover
theSpinel -
25 May 2006 3:02 AM - 4 messages
Is it possible to failover a single or a selected number of databases onto a standby server? We're currently log shipping about 12 databases to a standby and I was wondering if it was possible to randomly failover onto selected dbs. ...
Indexes on Joined Columns
cbrichards via SQLMonster.com -
24 May 2006 11:00 PM - 7 messages
I have the following select statement used to create a view: select st.col1, st.col2 from FirstTable ft inner join SecondTable st on ft.coluid = st.colfid ...
Full-text search services on existing cluster node?
D_M_S -
24 May 2006 9:53 PM - 2 messages
We have a two node cluster that is currently running two instances of SQL 2000. It turns out that one node has full-text search installed while the other node does not. Is there a way to install full-text search capabilities on an ...
Upgrade Advisor
RobYslas -
24 May 2006 9:11 PM - 2 messages
The system I am trying to run UA against has a named instance. The instance name contains a \, as soon as I type this character into the wizard, I get a message that indicates that this is an invalid instance name. ??? ...
add event to application log
doug -
24 May 2006 8:58 PM - 2 messages
How do I add events to be recorded in the application log? I have a process that is not completing 100% of the time, but I am not getting any events recorded in the application log. The severity must be < 20. I realize that ...
Logging User
Chris Marsh -
24 May 2006 8:42 PM - 3 messages
Hi, I am trying to log the exact user (a.k.a., Domain/User) into a column in X data table. Currently, our users login with a connection string passing Mixed Mode Authentication with username/pwd. Again, what we want to capture ...
How I see what Service pack I have
Rafael Tejera -
24 May 2006 8:17 PM - 3 messages
I cannot find what service pack I had install in my Server. Can anyone tell me where I can see it. Rafael ...
Visual Studio Install and SQL install
Kevin Burton -
24 May 2006 8:12 PM - 4 messages
It seems that when I install Visual Studio I get SQL install and then when I try to install SQL 2005 I get errors (Mainly duplicate instance errors. Since it does not say what the instance name conflict is I don't know how to ...
Newbie - Help with Constraints
Johnny Meredith -
24 May 2006 8:07 PM - 4 messages
Dear all, I am new to SQL Server (using the express edition.) I need to set up a contraint that checks values from one column in three tables against one column's value in a pending insertion. If the value that is ...
sql server 2000 & update record
Simone -
24 May 2006 7:30 PM - 5 messages
In a win sql server 2000 I have a table with this columns: name, department, credit. When a row is created 'automatically' (by a third part software) the credit value is set to 20. Now I need this: When a row is created and the departement record is set to Disney ...
Enterprise Manager not in programs list
BruceS -
24 May 2006 7:19 PM - 4 messages
Hi There, I have SQL 2000 running on my 2003 server. The service is running in my system tray, but when I go to start-programs, my MS SQL-enterprise manager has disappeared. It has been there in the past and I have done a re-boot. ...
Non Windows App connecting to SQL Server using Windows Auth
Hassan -
24 May 2006 7:06 PM - 2 messages
How can a non Windows App , say an app that runs on Linux connect to SQL Server using Windows Auth ? Has anyone done that ? How does Linux integrate with Windows ? Are there 3rd party tools ? We know SQL Auth would work but we want to use Windows Auth only. ...
c0000005 EXCEPTION_ACCESS_VIOLATION after stopping/starting servi
Mark Kuntz -
24 May 2006 6:21 PM - 4 messages
On a nightly basis, SQL services are stopped to perform backups. Afterwards the services are started. This has been working for years. Middle of last week, SQL has been failing to start. SqlDumpExceptionHandler: Process 4844 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process. ...
Table With No Data But Use 38 MB?
ME -
24 May 2006 6:13 PM - 5 messages
I have a table with no data when I run sp_spaceused TABLE_NAME it shows rows = 0 reserved = 38096 KB data = 2528 KB index_size = 8 KB unused = 13560 KB I did DBCC UPDATEUSAGE, the result from sp_spaceused TABLE_NAME unchanges. What is the problem now? Thanks. ...
table
anonimo -
24 May 2006 4:34 PM - 6 messages
is there any way to see if a table was modified ? if was using an insert, delete or update? thanks. ...
auto uncheck the table ownership
kennywcy -
24 May 2006 4:29 PM - 4 messages
I have database called "backoff" at both server A and server B. Before the copy I set the "userA" have the table ownership. When I copy the database from A to B, the database is fine. But the security > logins > "userA" > database access its auto uncheck ...
Export script data from sql server - suggestions for this case
ina -
24 May 2006 4:11 PM - 6 messages
Hello Guys, I would like to export my database into a file in order to be used in another server that I do not know??? So, I would to be able to exprot all the table structure, stored procedures and data (insert into). ...
restoring from tape to different server
Andre Gibson -
24 May 2006 3:39 PM - 2 messages
hello all, I preform regular sql server 2000 backups on our production server (Windows 2000 Server). I now need to restore, the Production DB to the backup server (Windows 2000 Server) from tape (hp dds-4 data cartridge). The restore db ...
Bug Details: Unexpected behavior of Ident_Current() over SQL2005 SP1 x64
Angel. E. Ruiz. P -
24 May 2006 2:52 PM - 4 messages
Description: Opened by Angel Enrique Ruiz Pastor MVP VB on 2006-05-17 at 09:19:43 We are migrating our Database to a new instance on a SQL Server ...
Proactive Monitoring in SQL SERVER
José Júlio Duarte -
24 May 2006 2:26 PM - 2 messages
Good Morning, Please someone have a document with the necessary actions for the proactive monitoring. I need this document for the implementation of alarms in SQL SERVER, for example send an alarm when the tranasaction Log reaches determined percentage. Thank You ...
Apply a long list of SQL Statements
Samuel Shulman -
24 May 2006 2:13 PM - 6 messages
I just received a long text file that contains all statements required to create all necessary tables as well as inserting all the data into this table Using the Enterprise Manager how can I apply all these statements? Thank you, ...
Internet database
April -
24 May 2006 1:52 PM - 2 messages
I am a complete newbie to administering a SQL Server database that's on the internet, so please don't assume I'll be able to take anything as a given. I have a website that's driven by coldfusion and a SQL Server database. I ...
Find tables in packages (SQL2000)
esapoznik -
24 May 2006 1:34 PM - 3 messages
Hi!!! We have about a houndred packages made with Enterprise Manager. Is there any tool in SQL (or code) to find a certain table involved in a package? eg: I need to know in which packages is involved the table ...
How to manipulate column data to place in a temporary table
stephen.tys -
24 May 2006 1:20 PM - 7 messages
Hi all. I'm afraid I'm guilty of a cross-post here. But time is of the essence and it is fast running out. What I'm trying to do is copy a column of data, [Description], from ...
heap tables
Jason -
24 May 2006 12:20 PM - 9 messages
Hi, What DBCC statement can i use to do maintenance on system and heap tables. If i do a dbcc showcontig, i see that the system databases are heavily fragmented. In case of heap tables i see that the average free bytes are ...
SET ARITHABORT ON: Why (not)?
Pieter -
24 May 2006 12:13 PM - 5 messages
Hi, I recently started using Indexed Views in my SQL Server 2000 (Enterprise Edition), so I need "SET ARITHABORT ON" when doing an insert or update on one of the concerend tables. I was wondering if it would be 'better' to set the ARITHABORT ON for the ...
Question about Back ups
Chris -
24 May 2006 12:06 PM - 7 messages
I have a production server that has a lot of data changes through out the day. I do one full back up at night and do hourly log back ups through out the major part of the day. My question is when I do the full back up does it back up the log as well ...
How to prevent users to see databases apart their own
Ivan -
24 May 2006 8:48 AM - 13 messages
Hi, We are hosting multiple sql server 2005 databases on a windows 2003 server. I wold like to know how to prevent users to see databases apart their own, if they are connecting to server with SQL Server Management Studio. ...
Neverfail vs Mirroring
TomT -
24 May 2006 4:52 AM - 11 messages
My company is considering using Neverfail, or SQL 2005 database mirroring as a failover solution. I'd be grateful for any feedback on the merits of either of these. Has anyone tried both? I'm curious as to how they compare. ...
need solution for change file path
zouky -
24 May 2006 3:19 AM - 2 messages
greeting, i would like to ask some question about MS SQL 2000 Server. recall: during the installation, for the setup type, there's one setting for the destination folder for (1) program files and (2)data files i need a solution for: ...
SQL Server Object and Counters
Sal -
24 May 2006 3:07 AM - 3 messages
Hi: I am trying to use windows performance monitor to watch some of the these counters, i.e., SQLServer:General Statistics—User Connections, SQL Server: Locks etc. I cannot find SQL Server Object and its counters on performance monitor. ...
OPENQUERY problem with dynamic result set
jalbenberg -
23 May 2006 11:23 PM - 3 messages
I am having a problem with OPENQUERY in SQL2005. SELECT * FROM OPENQUERY(MySQLServer, 'EXEC myProc') This generates an error along the lines of: The OLE DB provider "SQLNCLI" for linked server "MySQLServer" indicates that either the object has no columns or the current user does not have ...
Deciding which indexes to defragment
pshroads -
23 May 2006 10:47 PM - 2 messages
I want to start monitoring index fragmentation and defragmenting as necessary. My indexes have never been defragmented so I am trying to determine which ones I should start with. I've run DBCC SHOWCONTIG and saved the results to a table. What criteria should I use to determine ...
|
|||||||||||||||||||||||