|
sql
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Microsoft SQL Server Administrationmicrosoft.public.sqlserver.server
License
Curtis -
18 Nov 2006 10:34 PM - 3 messages
I am using 2005 standard edition with one cal. Does this mean if I am logged in using vs 2005 or the management studio that a web connection will be denied because I am already using the one license? ...
Reset data in DMVs
Hassan -
18 Nov 2006 9:47 PM - 2 messages
Is there a way to reset the data for some DMVs like the one for waitstats,etc ? ...
Export Data from SQL Server 2005
Ganesh Muthuvelu -
18 Nov 2006 7:54 PM - 3 messages
hello, In our .NET application, we have an interface where users can type/execite any query/stored porcedure and export the results to a flat or Excel file. We were using DTS objects to do this. Now that DTS is dead and we need to ...
'SQLOLEDB' was unable to begin a distributed transaction
tebaida -
18 Nov 2006 7:40 PM - 2 messages
hello, i am running SQL Server2000 on a Windows 2003 R2 and if try to run procedures or statements in transaction I get the following error: " 'SQLOLEDB' was unable to begin a distributed transaction" i have followed the instructions in articles: ...
Repost: Data not being partitioned properly?
ChrisR -
18 Nov 2006 6:30 PM - 6 messages
Thanks to David Browne for pointing out my mistake yesterday. But I have implemented the suggestion and am still experiencing the same behavior. I'm sorry to to keep posting partioning questions here, but the concept has sparked a huge interest at my work and I need to answer lots of questions. ...
I can't get rid of ExtentFragmentation on a few primary keys
John -
18 Nov 2006 4:33 PM - 4 messages
I have many tables with primary keys that look like the one below. I've tried Create index with (drop index), dbcc dbreindex and dbcc INDEXDEFRAG (with a fillfactor of 80). But nothing seems to correct it. There is a few ...
Transaction log backups
pkelly -
18 Nov 2006 4:19 PM - 4 messages
We are backuping up our transaction logs every hour. We have tested and all seems to be working well. My question is how do I neatly clean up the transaction logs after they have aged? Can I just delete the ...
sys.dm_db_index_usage
SalamElias -
18 Nov 2006 3:40 PM - 2 messages
Is there any detailed explanation for results of "sys.dm_db_index_usage_stats" DMV for example,if we have this combination ----------------- Object ID = 1, index id = 1, user seeks =2, user scans = 8, user lookups = 2 Object ID = 1, index id = 4, user seeks =2, user scans = 0, user lookups = 0 ...
vb sqlserver 2000 Backup Restore
Arejan -
18 Nov 2006 2:09 PM - 4 messages
how to backup and restore sql server 2000 database while the server is running using VB6 [link] will it not restore if the server is running shall i go for SQLDMO.Restore ...
Data not being partitioned properly?
ChrisR -
17 Nov 2006 11:31 PM - 3 messages
Howdy all. Im trying to take advantage of this new feature, but it's not working as I had expected. Below is the DDL and DML, with explanations of what Im trying to accomplish and where my confusion is. USE [AdventureWorks] ...
Running Query Analyzer on a workstation
RobW -
17 Nov 2006 10:24 PM - 4 messages
We have a test SQL database installed on a workstation that we use for testing purposes for a server running ERP software and SQL Server 2000. I believe the workstation just has a desktop version of SQL. I need to be ...
exclude system tables in metadata
Dana -
17 Nov 2006 10:23 PM - 4 messages
I want to get a list of user tables that excludes dtproperties and sysdiagrams. In Management Studio these two tables show up in their own Tables > System Tables folder. However, both sys.tables and INFORMATION_SCHEMA.TABLES include dtproperties ...
SQL Server 2005 Database Engine Connect
masmith via SQLMonster.com -
17 Nov 2006 10:22 PM - 2 messages
Is there anyway to change the Windows Authentication user name to another user when connecting to a datbase engine. I simply cant figure out how to do this ...
strip the number
klabu -
17 Nov 2006 9:42 PM - 2 messages
How to strip the number and leave only decimals ? e.g 12.25 --> .25 17.30 --> .30 I need .25 & .30 thanks ...
Identify the reason for a Deadlock
Double_B -
17 Nov 2006 8:17 PM - 6 messages
Hi Can we identify the reason for a Deadlock , after it has passed. I mean can I get to knw the reason as to why the deadlock occured yesterday on my production box. I had not left the profiler on ... neither did I send the dead lock ...
Justifying More Memory
wreaves -
17 Nov 2006 7:53 PM - 3 messages
I read on SQL-Server-Performance.com that it is recommended to size you memory to the size of your largest database due to SQL server caching agent not using windows virtual memory correctly. I went and informed the management of this and they would like more justification? Does ...
Securables
Leila -
17 Nov 2006 7:09 PM - 3 messages
Hi, Why a SQL Server Login is securable? How do we secure it? Thanks in advance, Leila ...
How do I restore a database that is in use?
apf -
17 Nov 2006 6:39 PM - 6 messages
I have a massive transaction currently rolling back (I killed the spid.) The estimation is that it will take this transaction many hours to roll back. I've decided it will be faster to just restore a previous backup of the ...
Unknown Error with MDE file
jamie -
17 Nov 2006 6:37 PM - 4 messages
Over the last week, when trying to run our MS Acesss DB via an MDE file, various people have received the following error. "The expression On Click you entered as the event propoerty setting produced the following error: The operation on the | object failed." ...
Indexed view appears slower
thejamie -
17 Nov 2006 5:58 PM - 8 messages
Placing an indexed view into a query appears to slow the query down. There is a cross database reference to a table which has its own indexes. Creating an indexed view similar to the table minus a field or two and substituting ...
Cannot change tran log to "unrestricted" growth
KJ -
17 Nov 2006 5:34 PM - 9 messages
This script has no effect, growth stays "restricted" to 2GB, even after executing this script: ALTER DATABASE [MyDB] MODIFY FILE ( NAME = N'MyDB_log', MAXSIZE = UNLIMITED, FILEGROWTH = 10%) Any ideas why this might be happening? ...
Problem with top 1. urgent help needed
Rajeev -
17 Nov 2006 5:16 PM - 2 messages
If i remove the added code and run the below query, i get the following output ( for fileid 1591673) SELECT HSA.Fileid, --PPA.CoordinatorLastNm, --PPA.CoordinatorFirstNm, PPA1.LastNm + ',' + PPA1.FirstNm AS CSCName, PPA1.ElectronicNo AS CSCEmailId --PPA2.LastNm + ',' + PPA2.FirstNm AS RCO ...
Search Criteria and UniqueIdentifier
cbrichards via SQLMonster.com -
17 Nov 2006 4:41 PM - 2 messages
I have an archive table that monthly I have a job that writes the last months data to a file and then deletes that months data from the archive table. The months worth of data is close to 20 million rows. ...
Should I be concerned about this?
Greg -
17 Nov 2006 4:16 PM - 6 messages
Event Type: Information Event Source: MSSQLSERVER Event Category: (2) Event ID: 17055 Date: 11/17/2006 Time: 5:00:03 AM ...
Revert to checkpoint
r.oosterholt -
17 Nov 2006 4:10 PM - 6 messages
Hi, Our application has an automatic software update feature. We want to create a checkpoint (certain point in time) in the database in order to revert to this checkpoint when somewhere in the software update sequence error(s) occur... Is this possible in MSSQL? ...
Online Reindex Build Perfomance Issues
Bob Sills -
17 Nov 2006 4:05 PM - 3 messages
We are in the process of testing online reindex rebuilds on a 260 Gig database on a table with 40 gig of data and an index size of 42 gigs. We are finding that this process is taking up a substantial amount of ...
SQL Server 2000 EM Register SQL Server W/O GUI
Joe K. -
17 Nov 2006 3:24 PM - 2 messages
Is there away to register SQL Sever 2000 database server with or without the Enterprise Manager GUI with a different Windows user account? I would like to register approximately 20 servers from a single server but I do not have all the sa passwords for the servers. But I do have the ...
About database maintenance
Iter -
17 Nov 2006 3:18 PM - 4 messages
Hi Guys, I have a question regarding database maintenance. I am new dba in a development team. I don't know what else I need to do except data backup. Do I need to do rebuild index and update statistic every night? What else do I ...
Exec SP_Executesql @Selectstring
mecn -
17 Nov 2006 3:15 PM - 2 messages
Hi, How do I assign the select statement result to a variable? Select @Myvariable = Exec SP_Executesql @Selectstring It donesn't work. Any ideas? Thanks ...
any ideas?
Mike Read -
17 Nov 2006 3:12 PM - 2 messages
I have a system currently runs in house only. The system is for enforcement officers where they are creating and working on case files. When they create a new case, the insert statement has logic that will go out and find the last case number used and then increment that number by 1 and ...
Total Number of Records from Several Views
SQL_Rookie -
17 Nov 2006 2:58 PM - 3 messages
Hey everyone, Let me say thanks in advance for any assistance I receive. I need to get a total number of records from 4 different views. I'm trying to incorporate this into a function that is being written. Please forgive ...
change precision in a table column
Brian -
17 Nov 2006 2:52 PM - 8 messages
Running SQL 2K sp3a, db is on compatibility level 65. I need to change the precision of one column in a table. I scrioted the drop and recrete of the table in EM. Made the change I needed to the precision on the one column in ...
SQL 2000 restore problem
Tom W -
17 Nov 2006 2:19 PM - 4 messages
My agency bought a new server to replace an existing server that hosts sql 2k (sp4). I want to use this to document/test steps that I'd take in a disaster recovery scenario. Both servers are in the same domain. ...
Advice about database deployment
buzlite@sympatico.ca -
17 Nov 2006 1:46 PM - 6 messages
Hello All, I am writing a database application that will serve multiple companies, each company contains users that will store/retrieve data from the database. I am in the process of deciding whether I should have one big database that stores data for all users of all companies or have a separate ...
Getting a syntax error involving Microsoft.SqlServer.SmoEnum
Rod -
17 Nov 2006 12:59 PM - 4 messages
Last month we upgraded our SQL Server 2000 production database to SQL Server 2005. It also has SP1 applied to it. I was just checking the jobs, making certain that everything was running OK. We have 7 jobs defined, when I ...
encryption--the sequel
childofthe1980s -
17 Nov 2006 12:44 PM - 2 messages
Hello: Earlier this week, I had posed a question on encryption and certificates. A very nice person gave me two blogs to read. I appreciated that and it was very helpful. Now, I just want to make sure that I have the order down pat. ...
Installation Date/Version Numbers
David Saunders -
17 Nov 2006 10:05 AM - 3 messages
Hi I am very new to SQL Server and am trying to gain some general information about it. What I am interetsed in is gaining either an installation date from the software and/or a current version that is running? Is it possible to get ...
Render Reports
somuthomas -
17 Nov 2006 9:23 AM - 2 messages
Hi, Can multiple parameterised reports be combined(or rendered) into one PDF or MHTML format? How is it done? Note: The reports generated have same structure but the values in the fields as the input parameter changes. Thanks in Advance ...
sp_indexoption
SalamElias -
17 Nov 2006 9:08 AM - 16 messages
I had aDB with 1 table that has 5.5 million records, with min row size = 209, ma row size = 1800 The Data physical file before creating a clustered index 6.224 g created clustered index on 4 columns, the DB data file grew to 13.427 G ...
Multiple files/filegroups
andrew -
17 Nov 2006 7:51 AM - 3 messages
Hi, We have a database which has reached our disk capacity of 340GB and we are looking at our options on how to resolve the disk space issue. The problem is I'm not too familiar with setting up additional filegroups ...
lock info
tin -
17 Nov 2006 4:50 AM - 4 messages
hi, from Activity Monitor, i found that there's a process (suspended) holding over a thousand locks on a table named tbl_BusinessRecordDetailed. i have 2 questions: #1 - is there a way to find out which row it's locking? #2 - what exactly is causing the locks? since the mode is S, which means ...
Transfer a stored procedure
clintonG -
17 Nov 2006 3:34 AM - 5 messages
I need to learn how to transfer stored procedures from one server to another. ...
Log shipping sync error 14421
krishna -
17 Nov 2006 3:10 AM - 4 messages
Hi SQLServer 2000 sp3 enterprise running logshipping smoothly, today its broken, out of sync error for all databases on standby server error 14421. I have manually restored all the log backups and updated manually log_shipping_secondaries columns set last_copied_last_updated & last_loaded_last_updated with 15 min difference which i have configured. ...
i have two inserts and one delete i want in one transaction, is there any issue with this tsql strat
Daniel -
17 Nov 2006 1:35 AM - 2 messages
i have two inserts and one delete i want in one transaction, is there any issue with this tsql strategy: [link] ...
what collation?
David Thielen -
17 Nov 2006 1:06 AM - 7 messages
Hi; We have a portal product we are about to start shipping. Over half of our customers are outside the US including both the middle east and far east. We have a schema.sql file to create the database on their computers. ...
SQL Server User License Question?
mike11d11 -
17 Nov 2006 12:52 AM - 6 messages
I'm trying to create an application that will access data on a Windows 2003 Server that has SQL installed. Right now I'm testing on another machine that has SQL on it already and is not an 2003 server. So realy ...
Object Explorer
tawright915 -
16 Nov 2006 11:38 PM - 2 messages
I installed SQL server 2005 Standard Edition on a new Dell server with AD and Win2003 server installed. After the installation of SQL server 2005, I cannot seem to find the shortcut to object explorer. All I have are shortcuts to Config ...
SQL server as web hosting
lwidjaya -
16 Nov 2006 10:58 PM - 3 messages
Hi, One of our SQL servers is also our extranet hosting. Is that why this server not joined to the network domain (so people can login from outside)? As far as I know, only our sales people who login to the extranet but they're all ...
log shipping between 64 and 32 bit servers...
TrevorD -
16 Nov 2006 10:13 PM - 2 messages
Hi, I am just wondering if you can do log shipping with 2005 between a 64 and 32 bit versions. We have a 32 bit server now that will become the backup and are looking at purchasing 64bit server to make use of oodles ...
How to identify 2005 vs 2000 backups
Rob Diamant -
16 Nov 2006 9:14 PM - 3 messages
Can anyone guide me on how to determine if a backup is a 2005 or 2000 database. Is there some identifier bytes I can look at to determine the correct version. I have no problem writing a utility to scan a backup file for the correct ...
round to nearest WHOLE number
klabu -
16 Nov 2006 8:59 PM - 2 messages
T-SQL: How to round to the nearest WHOLE number ? so from --> to ------------- 170 --> 170 96.58 --> 97 thanks ...
Point-In-Time Restoration Problem
Jerry -
16 Nov 2006 8:49 PM - 2 messages
I'm learning how to restore a database to a point-in-time. I set up a database called DR_TEST and a table called tblTest with a single varchar column. I back up the database using the following command: use master ...
One Unique Field
anthony -
16 Nov 2006 8:48 PM - 3 messages
I have a table with 4 fields, that can contain duplicates. I have to build a new table where field3 is the primary key, no duplicates. How do I write the SQL to return all the rows only were filed3 is ...
TLog out of control
cbrichards -
16 Nov 2006 8:33 PM - 4 messages
I just had a transaction log that was growing at about 2 gigs a minute. It was growing so fast that we felt we had no choice but to stop and restart the service. Part of the problem is that we did not know how to track down what the ...
can someone login as "NT AUTHORITY\SYSTEM "
Dan D. -
16 Nov 2006 7:20 PM - 8 messages
Using SS2000 SP4. Can someone login as either NT AUTHORITY\SYSTEM or NT AUTHORITY\NETWORK SERVICE? I'm trying to figure out how someone got access to one of our servers. I log both the failed and successful logins and both of ...
Increment thru dates
juya -
16 Nov 2006 6:59 PM - 2 messages
Hi all, I have a clearly simple question. I just need to iterate thru dates that are passed as parameters - From date and end date. I need to execute the following code that currently loops. I am not exactly sure ...
is there a way to truncate server logs
Dan D. -
16 Nov 2006 6:42 PM - 3 messages
We haven't rebooted the server in months and now when I go into EM, Management, and SQL Server Logs it takes forever for the logs to display. Is there a way to roll over to another log or truncate the existing log file so ...
List of running stored procedures
Jim -
16 Nov 2006 6:39 PM - 8 messages
Is there any way of generating a list of running stored procedures? ...
DTS Versus Linked Servers
Scott Yu -
16 Nov 2006 6:12 PM - 2 messages
Hello Everyone, Is it usually faster to transfer data using DTS or over a Linked Server? Thank you. Scott ...
Remote Production Database Issue
Scott Yu -
16 Nov 2006 6:11 PM - 2 messages
Hello Everyone, Can someone please give me some ideas on how I can maintain a database on a development environment with data that was entered by users from a remote production site. I have no direct access and can not remote connect to the remote production ...
Need help troubleshooting a memory paging issue
pshroads -
16 Nov 2006 5:37 PM - 4 messages
I recently discovered that my server is doing a lot of paging (as measured by the 'Memory: Pages/sec counter') and I'm not sure why. Each day around midnight paging goes from near zero in to the several hundreds. It stays at that level until about 9 or 10 AM and then drops ...
CHECKING the TRANSACTION LOG
Tom Reis -
16 Nov 2006 5:15 PM - 3 messages
I am running SLQ 2000 SP4. I used to use the DBCC CHECKTABLE (syslogs) to check the transaction log on a SQL 6.5 server. This doesn't work on a SQL 2000 Server. Is there a equivalent command or procedure. Thanks. ...
limited permissions on test server for developers
andy -
16 Nov 2006 4:41 PM - 4 messages
I want to give developers limited permissions on a test sql server 2005 database. Basically they should be able to add columns to a table or modify a columns datatype. Create table and view definition have been granted to the developer ...
Out of disk space
danielp -
16 Nov 2006 4:35 PM - 2 messages
What is the impact to SQL Server 2000 (sp1) databases should the disk run out of space? ...
Truncating Transaction Log
ngorbunov via SQLMonster.com -
16 Nov 2006 4:28 PM - 2 messages
The database is transactional and I don't mind truncating the older transactions as we have it all backed up but I don't want to truncate recent transactions in the log. So can you delete lets say transactions in the log that are older than 3 ...
how to remove the sql server registry mess?
gs -
16 Nov 2006 4:28 PM - 4 messages
after uninstalling the sql server and related stuff, I found tons of sql server registry entries. How do remove them all properly? any script or tools. I tried the setup form disk to remove but still no joy ...
Installed SQL2000 SP4 successfully but still shows RTM as installe
Kristen -
16 Nov 2006 4:28 PM - 2 messages
After installing SP4 on server, I checked ProductLevel and Productversion and they still showed RTM and 8.00.194. I did see a whitepaper about this regarding SP1 and the fix was to apply the latest SP which is SP4, so this does not apply to me. ...
Low Disk Space
thejamie -
16 Nov 2006 4:07 PM - 5 messages
When we setup SQL 2005, it was setup to house the log files on a larger drive. It was not setup to house the tempdb files when they grow to a large size. We are running out of disk space on the C:\ drive. Is it possible to ...
Delete records in a table with 15 dependencies
mecn -
16 Nov 2006 3:31 PM - 3 messages
Hi, I need to delete records in a table with 15 dependencies. I can't drop the 15 dependencies before delete records. Any ideas to delete records without dropping dependencies Thanks, ...
Spid checker query help
fnadal -
16 Nov 2006 3:21 PM - 2 messages
I have this query that I use to check "behind the scenes" on all the processes on the Database. However it doesn't show me the actual spid in the results. My problem is the 'insert into #tmp EXEC (@strSQL)' line. If I ...
DUMP TRANSACTION
Tom Reis -
16 Nov 2006 3:17 PM - 3 messages
I am running SQL 2000 SP4. I see the DUMP TRANSACTION command in BOL and other Microsoft documentation but it doesn't seem to work. Is it still supported. The command I am using is DUMP TRANSACTION WITH NO_LOG. ...
What is the database option supplemental_logging?
Terry -
16 Nov 2006 2:47 PM - 2 messages
This appears to be new in SQL05, and may not even be activated. Anyone know the use or intended use of this setting? Terry ...
Batch scripts
kailash -
16 Nov 2006 2:25 PM - 2 messages
Hi All, Could you please provide me brief description of batch process. What is batch process? How to run batch process ? with example ...
Out of the box reports
tonyf01 -
16 Nov 2006 1:03 PM - 2 messages
Hi My company is planning to deploy SQL Server 2005 Reporting Services to monitor usage of a number of sites we've created using Sharepoint. The marketing blurb says that a number of out-of-the-box reports are available but doesn't say exactly what these reports are. Can someone ...
Drop table , procedure Problems
plmanikandan -
16 Nov 2006 11:19 AM - 3 messages
Hi, I'm creating table, procedure from my c# codings in sql server. I'm having database owner rights. My problem is sometimes the table, procedure is created with username.tablename instead of dbo.tablename. so i'm unable to drop that ...
except keyword
kalaivanan -
16 Nov 2006 10:15 AM - 10 messages
hi, how do i use except with my result sets. any example please. kalaivanan ...
Dynamic SQL or Table Variables??
Nemisis -
16 Nov 2006 10:10 AM - 2 messages
Hi all, I was wondering if anyone knew all the pros and cons about using table variables instead of dynamic SQL, and vice versa?? Problem i have, is writing a stored procedure which allows users to search for particular records in the database. This is fine when all ...
Changing owner of DB objects
Gav -
16 Nov 2006 9:24 AM - 5 messages
I have a database where all objects within it and owned by a user not dbo. Is there any way I can change all the object ownerships to dbo? I'm talking thousands of objects so I'm thinking some form of script. ...
database file does not auto grow
Richard -
16 Nov 2006 8:08 AM - 11 messages
Sql 2000 Enterprise SP3 Our current database is 25gb large but grows no longer automatic. How this are possible? Properties: Automaticlly grow file File growth by percenrtage 10 % Maximum file size Unrestricted file growth ...
Create the SessState table (osql.exe -E -d SessionDemoDb -i Session.sql).
princessjewel62 -
16 Nov 2006 4:49 AM - 3 messages
Hi all, I've read Billy Yuen's documentation about session sharing and decided to try out the demo. But the problem is that, I am new to web development and I have little experience in Microsoft SQL Server and ...
Query plan different in different instances
VIKING -
16 Nov 2006 1:48 AM - 2 messages
Hi there, I am not sure if this post is relevant to this forum, but I am desperate to find an answer for my problem. Here goes my problem, I have a query SELECT BPE.[EmpLastNm]+' '+ISNULL(BPE.[EmpFirstNm],'')+'('+ISNULL(BPE.[EmpFamiliarNm],'')+')' AS ...
Running SQLSERVER2005 with SQLSERVER2000
Ant -
16 Nov 2006 1:35 AM - 3 messages
Hi, Is it possible to run SQL2000 on the same machine as 2005? Will there be any major problems? Can it be done at all? Will they simply be treated as seperate applications? Thanks for your help on this. Ant ...
Backups taking progressively longer
AkAlan -
16 Nov 2006 12:48 AM - 11 messages
My Backups are taking progressively longer to complete. I run Full once a week, Differential once a night and TLogs every hour. The TLogs are what are really bothersome. They used to take less than a minute but now are going on ...
How to write a trigger for date last modified...
dhooger -
16 Nov 2006 12:18 AM - 3 messages
I'm in SQL Server 2000 and need to write a trigger for date last modified. I've created a column (date_last_modified) and have written this so far... CREATE TRIGGER DATE_LAST_MODIFIED ON [dbo].[TABLE_NAME] FOR INSERT, UPDATE AS UPDATE TABLE_NAME SET DATE_LAST_MODIFIED = GETDATE() ...
convert rows to columns
Ashutosh -
15 Nov 2006 11:55 PM - 4 messages
I hope I am able to explain you my situation I have a table called levelAllocation. A snapshot of the table looks as follows LAID LVID ALID PERCENT 1 1 4 10 ...
Locking down access when a vendor application package doesn't
Steve -
15 Nov 2006 11:16 PM - 2 messages
We have a situation where a vendor requires all users to be in a role. Good, right? Well, it's a single role with all access to all tables and sprocs within the database. The vendor then controls specific access levels ...
Multable database on one machine
Lee J -
15 Nov 2006 11:12 PM - 5 messages
Total newbie question i know. The company i just started working for has SQL 2000 installed on four machines. Is there any info i can get about putting all database on one machine, Then having an application server running the apps (Great Plains ...
blank textbox is NOT null ..
jobs -
15 Nov 2006 10:56 PM - 2 messages
This must be a common asp.net / sql server problem. I only want to filter on the date when the filterdate textbox has a value. Not sure if this is the best approach, but it does not appear to be working.. I was hoping blank mean no filtering and all qualifying ...
Diffrence between 2 tables in MS Acess
jamie -
15 Nov 2006 10:15 PM - 16 messages
Hello, I'm trying to find the diffrence between two linked tables, from SQL server, in MS Access. Table (1) contains inquiries whereby the 1st 2 leters relate to a Distrcit in the Distrcits table. I would like to ...
Database Maintenance - Order of Actions
KellyLeia -
15 Nov 2006 9:55 PM - 4 messages
Is there anyway to make the maintenance plan delete the backup files BEFORE it backs up. My backups are failing due to lack of disk space, because it essentially creates two copies of backups before deleting. I know i can just write a script to delete them before hand, but it ...
Large Index
Zack -
15 Nov 2006 9:37 PM - 6 messages
Is it normal for Index size to be three times the size of its corresponding table in SQL 2005 ...
Index size
Zack -
15 Nov 2006 9:06 PM - 3 messages
Is it normal for Index size to be three times the size of its corresponding table in SQL 2005 ...
isnull logic changes
jobs -
15 Nov 2006 8:35 PM - 6 messages
using asp.net sqldatasource selectcommand to populate a datagrid. I have a parameter that might be empty or null. How can change logic based on it having a value or not.. for example select * from table where x=@x and y=@y ...
Lines disappear
Rich -
15 Nov 2006 7:27 PM - 4 messages
Hello Group, has anyone ever seen this problem. I was asked to work on an old database from project I had not been on (when does that ever happen...) anyway I go right to the database diagram to get a look at what I am dealing with. When ...
Why is the data in Primary instead of my Partition Scheme?
ChrisR -
15 Nov 2006 7:15 PM - 5 messages
Howdy all. If I create a Primary Function (PF), a Primary Scheme (PS), then create a table on it and run sp_help, it shows the data_located_on_filegroup as the PS. But then I add a Primary Key (PK) (to the Primary filegroup, I ...
How to list all tables and their size
Zack -
15 Nov 2006 7:05 PM - 3 messages
Is there a stored procedure to list all tables and their size, and / or number of rows Is there a stored procedure to list all indexes and their size ...
Additional IP for SQL Cluster
Dragon -
15 Nov 2006 5:47 PM - 4 messages
Hi, We have a two node failover SQL 2000 cluster setup. These servers are on a closed netowrk where they do not have access to internet or anything other network. I now have a need to be able to connect to the SQL server from ...
SQL Server Licensing
nanda -
15 Nov 2006 5:46 PM - 2 messages
We have one prod server with SQL Server enterprise edition. we would like to setup dr site server with a prod database replicating data to dr site (not to use logshipping). the dr site is used only in case of disaster and primary ...
Update Logs/Monitoring
David Saunders -
15 Nov 2006 4:25 PM - 3 messages
Hi I am interested in seeing all upgrades and change made to a SQL 2000 database. Are there are any logs kept in SQL 2000 that tell you all of the changes and upgrades made to the DB since installation? ...
Bound SQL to IP address
Silmar -
15 Nov 2006 3:18 PM - 2 messages
Hi! If there are a few NIC installed in server is it possible to make SQL Server 2000 listen only on specific IP address? Regards Silmar ...
|
|||||||||||||||||||||||