|
sql
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Microsoft SQL Server Administrationmicrosoft.public.sqlserver.server
grant permission problem on functions that returns table data type
she -
19 Nov 2005 11:57 PM - 2 messages
problem on grant permission to user Was this post helpful ? I have two kinds of functions in the database that need to grant exec permission to user appUser. The first kind of function return ordinary datatype, let's call it ...
enterprise manager on Windows XP x64
Vlado Jasovic (www.excelleinc.com) -
19 Nov 2005 11:19 PM - 2 messages
I have just installed Windows XP Pro x64 on new computer and having hard time installing enterprise manager (SQL Server 2000) to connect to my SQL 2000 Server running on remote machine. Is there any version of SQL Client Tools for x64 or I have to purchase SQL ...
sql server cpu utilization is high(99%)
subbu -
19 Nov 2005 10:57 PM - 3 messages
I am testing an application that generates SQL queries (only select) automatically , will be executed at SQL Server (System conf is mentioned below) . The database size is 400MB. The CPU goes to 100% within a minute of starting the application. It keeps maintain 100% though i stop the application ...
force protocol encryption on the server network utility registry setting
Joel -
19 Nov 2005 3:04 PM - 3 messages
Does anyone know when the registry key is to unset the "force protocol encryption" on the server network utiltiy is? Thanks ...
Triggers help
Islamegy® -
19 Nov 2005 2:55 PM - 3 messages
I need an Insert trigger to generate new tables when i insert a new record.. new tables will be "MasterSub_[ID]" where ID is the id of new inserted parent record.. ---------------------------------------- CREATE TRIGGER GENRATE_CHILD ON [dbo].[Country] FOR INSERT AS ...
timeout login the application
mkandari -
19 Nov 2005 11:14 AM - 3 messages
Hi I'm developing an application in VB using ADO and I'm connecting to SQL Server 2000 (SP3). can i make the application to timeout if the user did not make any transaction after say for example 20 seconds ? ...
Q: BAK file size
JIM.H. -
19 Nov 2005 2:59 AM - 4 messages
Hello, I have 4GB database BAK file in my laptop and I need to transfer it to another laptop. I zipped the BAK file and it reduced the size up to 2GB but I do not know how I can copy it to other laptop. I am wondering if there is any ...
Deleting records from a parent table
Craig -
18 Nov 2005 11:51 PM - 5 messages
How would I delete records from a parent table if it had no children? I know this seems backwards but that is what I need to do. Like..... delete from tblParentRecords if count of tblChildRecords = 0 or something like this. ...
Performance of SQL2k5 vs SQL2k
andsm -
18 Nov 2005 9:36 PM - 12 messages
I have SQL 2k5 RTM Developer Edition. Today I started to compare performance of SQL2k vs performance of SQL2k5. For several of tests I have seen 35% increase of performance of SQL2k5. But for most of tests, SQL2k5 have 60% ...
Extending Management Studio
Dan Jones -
18 Nov 2005 9:31 PM - 5 messages
Hi There, In SQL Server 2005 Enterprise Manager was rewritten and renamed to Management Studio. If ISVs (independent software vendors) could plug their SQL Server tool(s) into Management Studio – creating a single environment for you to work in – which tools do you use that you’d like to see surfaced in ...
trusted_connection
Paul DeWitt -
18 Nov 2005 7:16 PM - 5 messages
Hi, I have a .Net application I am developing which connects to a MS Sql server database. I currently am testing the location in a couple of locations. I am connecting to the database using a connection string. At some locations, ...
if exists
Mauro -
18 Nov 2005 7:14 PM - 2 messages
i have this: if exist(select * from sysobjects where name= 'table' and type = 'u' ) begin update table set a=1 where b=2 end and its giving me an "INVALID COMUN NAME B" error,because of course it does not exists ...
DROP PROCS
docsql -
18 Nov 2005 7:14 PM - 5 messages
Is it necessary to drop & recreate all procedures and triggers every few months? If yes, why ?. ...
permissions
docsql -
18 Nov 2005 7:13 PM - 3 messages
What is the difference between managing permissions through users and groups or through user-defined roles? ...
PK
docsql -
18 Nov 2005 7:13 PM - 4 messages
Are timestamp columns good candidates for primary keys? Why? ...
Securing a field, table or database
deltalimagolf -
18 Nov 2005 7:12 PM - 5 messages
Is it possible to secure a field, table or database to ensure that a specific piece of data can't view viewed by anyone except those who are authorized? For example a salary field of an hr database, allow only executive management ...
bcp batch file
cheilig -
18 Nov 2005 6:56 PM - 2 messages
created a batch file to bcp info out of tables. When executing the file it just loops on the first bcp statement without executing. The odd thing is I can't execute the bcp from the command line on the c: drive, but it will ...
Rotate table help
Randy K -
18 Nov 2005 6:41 PM - 3 messages
I need to join two tables I guess in a rotate fashion but have not been able to figure it out. We have a Taxo_Status table that contains up to 2 entries per species. These records need to be joined ...
Forums for posting SQL query coding questions?
Randy K -
18 Nov 2005 6:14 PM - 4 messages
Are there any free / public forums for posting SQL coding questions? I'm needing assistance on a table rotate type query. ...
Test Database
Peter Sturm -
18 Nov 2005 5:29 PM - 2 messages
Hello, I have very little experience with SQL. I am tring to install an program that needs to access the SQL server. In the software it test the SQL connections by creating, bulk inseting and then deleteing and database ...
stored procedure question
soe201 -
18 Nov 2005 5:16 PM - 5 messages
I like to use a stored procedure - lets call it usp_A - to run several commands sp_addrolemember on tempdb database after my SLQ Server restarts. ----------- USE tempdb GO create procedure usp_A AS EXEC sp_grantdbaccess 'domain\myAccount', 'myAccount' EXEC sp_addrolemember 'domain\myAccount', 'myAccount' ...
Sql 2000 Sp3a with CPU util between 80-95%
bjorgenson -
18 Nov 2005 4:48 PM - 7 messages
I have a SQL 2000 Ent. cluster. The active node is a 3 way, 4GB RAM server with DATA and LOGS stored on seperate SAN volumes. I have PAE enabled. I average about 40 transactions a second and my log cache hit ratio is ...
Shrink vs. Compress
MEB -
18 Nov 2005 4:25 PM - 4 messages
We have a SQL 2000 database that's 35GB. Using Enterprise Manager, I can't shrink it at all. It successfully performs the task, but there's no size reduction. If anything, I just lose space because the log file gets ...
Where does Text field data get stored?
MGeles -
18 Nov 2005 4:20 PM - 2 messages
Where does data entered into a Text field get stored? Is it in the index? ...
Disable MSX Functionality
Dave -
18 Nov 2005 3:47 PM - 3 messages
How do you stop an MSX server being an MSX server??? In other words, how do I get Enterprise Manager back to the state where under SQL Server Agent\Jobs I don't get sub-folders of Local and Remote, and I'm not allowed to target jobs at other servers? ...
DBCC CHECKDB error resolved with dbreindex - safe?
Joe Ross -
18 Nov 2005 2:18 PM - 4 messages
We had a hard drive failure in one of our RAID arrays. We've resolved the hardware issue; however, DBCC CHECKDB is showing errors in at least some of our databases. The way we structure our databases is with two data files, ...
Problem in Instead of Delete Trigger
vinoth -
18 Nov 2005 10:08 AM - 3 messages
Hi, I have Instead of Delete Trigger in my Table. When i delete any row from the table it shows the No of Rows affected ex:- 1 Row affected But when i look into the table the Deleted Row is still Present. ...
Unique query return
mark -
18 Nov 2005 8:59 AM - 4 messages
I need a query / SP that returns unique values from a number of columns in a table eg ID column1 column2 column3 column4 1 apple apple apple apple ...
Utf-8 and Sql server
Andrej ®eleznik -
18 Nov 2005 8:55 AM - 2 messages
Hello, We developed a web based application using utf-8 char set. How to configure sql server to run ok with utf-8 char set? Andrej Zeleznik Ljubljana, Slovenia ...
DB Backup Job for a Maintenance Plan taking a long time
Vince Keller -
18 Nov 2005 8:27 AM - 5 messages
Hello, I am trying to schedule complete backups of some of the databases that I have on my database server using the Database Maintenance Plan. However, when the DB Backup Job is run for backing up the database, it just keeps on ...
Sql Server Problem related to clustering
vibha -
18 Nov 2005 7:06 AM - 2 messages
Hello sir We have a very huge database its around 6 lakh records are being stored in it. records are not being a sorted order so we checked all ...
xp sprocs
Hassan -
18 Nov 2005 6:29 AM - 15 messages
Where can I find more info about all the extended procs out there For instance I ran xp_eventlog and it gave me an error Server: Msg 22005, Level 15, State 1, Line 0 Error executing extended stored procedure: Invalid Parameter ...
Left join ends up with more records
Joe -
18 Nov 2005 5:09 AM - 2 messages
Where am I going wrong here? I have a table tb_NoDupes in which I want to update a field (bntMemberid) with the value of the corresponding field on another table (tbMember). I'm writing to a new table the result. I start off ...
stored procedure with array of parameters
Rick -
18 Nov 2005 3:20 AM - 4 messages
1. Rick Nov 17, 12:44 pm show options Newsgroups: comp.databases.ms-sqlserver Date: 17 Nov 2005 09:44:28 -0800 Local: Thurs, Nov 17 2005 12:44 pm Subject: stored procedure with array of parameters Reply | Reply to Author | Forward | Print | Individual Message | Show ...
return IP address and disk usage of Server
Hassan -
18 Nov 2005 2:55 AM - 3 messages
What command can i run that will just ouput the IP address of a server ? Also, is there any command I can use to give me disk space usage i.e total space and free space Thanks ...
purging old backup and restore history from msdb
mmccarty -
18 Nov 2005 2:37 AM - 2 messages
I was able to find an article in the knowledge base detailing how to remove unwanted (old) records from the msdb databases for backups/restores that are no longer relevant in sql 6.5. I cannot find the same information for 7.0 ...
Change sql server connections from 32767 to 60000 or more
Hassan -
18 Nov 2005 1:07 AM - 4 messages
Is that possible ? BOL states that max user connections is 32767. Is that hard coded with SQL ? Or can I increase that to 60000 and have SQL open 60000 connections. Yes you may ask, why do I need and i understand that it all depends on ...
migrating MSDE to SQL Express Edition
dev dude -
18 Nov 2005 1:04 AM - 3 messages
Hi all, My application currently relies on MSDE 2000 and I want to migrate to SQL EXPRESS 2005. Currently, the application has functionalities like back up, recovery, capacity to shrink DB. It also relies on many longs stored procedures and long embedded queries. It also does sync between primary and sub ...
Problems updating tables after upgrade to sql 2005
DanielG -
18 Nov 2005 12:49 AM - 8 messages
Ok, upgraded our sql 2000 servers to 2005 and now a site using ASP 3.0 doing a RS.AddNew ... RS.Update is now throwing an error of Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find server 'NS1' ...
DATEDIFF order by problem
Aenim -
17 Nov 2005 10:45 PM - 5 messages
Hello All, Could any body tell me what the problem is with this select is giving me: (SQL Server 2000) Server: Msg 156, Level 15, State 1, Line 23 Incorrect syntax near the keyword 'order'. It runs fine when I take out the joins... ...
SQL Server Licensing
Wes -
17 Nov 2005 10:06 PM - 3 messages
Our company is currently developing an intranet web site. We purchased Sql Server Standard Addition with 10 CALs. We have between 150-250 users. We are using Forms authentication connecting to the SqlServer with one user login. ...
Need help about how to avoid bad plan used by the optimizer
harvinder -
17 Nov 2005 8:50 PM - 3 messages
Hi, We had the big table containing about 600M records and the following query used to take long time (this is subset of the query but this part takes the most time and is part of this question/discussion): Select top 1001 col3, col1, col4, col5 ...
Max Packet Size = 4096, but record size = 9077
MGeles -
17 Nov 2005 7:52 PM - 2 messages
There 's a server that is occasionally experiencing slowness issues. One of the queries that appears to hang during an instance of slowness involves a table with 560 columns and a waidth of 9077 k. The max network packet size is ...
Erratic connections to SQL database
mh1959 -
17 Nov 2005 7:50 PM - 3 messages
We are running SBS 2003 Premium with SP1. Each PC runs a small VB .exe, a booking program, which we use as a front end to SQL database. Since installing ISA Server 2004 and SQL2K SP4 several machines now have ...
Primary Key Convert from Non-Cluster to Cluster Index
Joe K. -
17 Nov 2005 7:35 PM - 9 messages
How do I convert a primary key field that was created with a non-cluster index to a cluster index? Please help me complete this task. Thank You, ...
Sql server agent service not started
Balram -
17 Nov 2005 7:00 PM - 9 messages
I installed sql server developer editopn in my system some days back , after a very long back now the agent service is not starting i tried with the following option to restrat the service 1. restart the agent using service manager ...
Create alert for table activity
doug -
17 Nov 2005 6:10 PM - 3 messages
Is it possible to create an alert to notify a user when a record is added to a specific table? This is a error log table so the activity would/should be very minimal. ...
Two Separate Restore Questions
Robert R via SQLMonster.com -
17 Nov 2005 6:08 PM - 2 messages
I just want to confirm what I am reading on BOL concerning a database restore. The [SOURCE] backup I have is from a different server, with different data and log file names than the DESTINATION database, and the SOURCE has ...
missing column after backup/restore
mp3nomad -
17 Nov 2005 5:49 PM - 3 messages
Just wondering if anyone has had any issues with backing up a database in SQL Server 2000 and restoring the database to SQL Server 2005 and having a column truncated in one of the restored tables. Very weird. I backed up a ...
problem in an update???
__Stephen -
17 Nov 2005 5:39 PM - 3 messages
Column is Varchar(100) code was: UDPATE productdesignprocessing SET BOOKCOLLATION = '30,30,30,30,30' WHERE PRODUCTDESIGNCODE IN ('WAL-UCO','WAL-KSS') why did I get an error NEAR = ? I changed it with a @var and it gagged on the code right after setting the ...
Table Structure Question
Mike Collins -
17 Nov 2005 5:29 PM - 5 messages
We are building a table and answer database. The answers will have required comments if the user selects anything below average. We believe the majority of the answers will be average (or above). Knowing this, should we create a seperate table to hold the comments so we do not have a column of mostly null ...
Indexed Views on SQL Server 2005 Non Enterprise
Jon Robertson -
17 Nov 2005 5:23 PM - 13 messages
The feature matrix for SQL Server 2005 states: "Indexed view matching by the query processor is only supported in Enterprise Edition." What does this mean in English? We use indexed views *a lot*. What is "Indexed view matching by query processor" ?!? ...
Third-Party Application Support
sfhank -
17 Nov 2005 5:12 PM - 2 messages
Are there any internet sites keeping tab on which third-party applications are being supported on the new SQL Server 2005 platform. For example, I'm trying to find out if RIM's Blackberry Enterprise Server supports their db on ...
Oracle as a linked server
natasa -
17 Nov 2005 4:36 PM - 2 messages
Does anyone know if Microsoft officially supports Oracle 9i as a linked server ? Thanks very much, Natasa ...
update statistics
mecn -
17 Nov 2005 4:30 PM - 3 messages
Hi, I am running reindex once a week. Do I really need to run update statistics often? What will happen if I don't run update statistics? Thanks, ...
Documenting Tables
Mike Collins -
17 Nov 2005 4:00 PM - 3 messages
Is there a way to document what a tables does within Enterprise Manager? I'm thinking no, so my next question is what is the best way to describe what a table is used for...aside from a descriptive name. Thanks. ...
store procedure cost
hongo32 -
17 Nov 2005 3:47 PM - 2 messages
hello, my boss tell me that i should convert a serie of sp's that doing small things... in one... that contain all the code and logic.... but the effort to maintain the code would be difficult, my question is: how ...
Change Logical File Name Containing a Hyphen
Skippy, DOT DBA -
17 Nov 2005 3:39 PM - 3 messages
I'm running SQL Server 2000. I have a DB with a logical file name containing a hyphen. When trying to change the size of the db and log files by running the following SQL statement it throws an error stating the file name is not ...
Memory Again.
Wind -
17 Nov 2005 3:36 PM - 2 messages
It's always about the memory. I have win 2000 advance server, SQL Server 2000 EE, 4G memory, not other application run on this server. How can I find out the exact memory usage for the SQL server. I guess the task manager will not show the correct number, so ...
How to install only SQLDMO on a Win98 client
Sylvain Aufrère -
17 Nov 2005 3:06 PM - 3 messages
Hello, I need to install only SQLDMO with my programm on a Win98 computer. Which are the necessary DLL and how to install them? Thanks ...
Windows Performance Monitor
Paul -
17 Nov 2005 2:29 PM - 2 messages
Hi: Do you have to use Windows Performance Monitor from the Server for sql server? Can I use it from my own computer? When I use performnace monitor from my computer, it defaults to my computer. Can I point it to the server? ...
TempDB
SalamElias -
17 Nov 2005 2:29 PM - 7 messages
Hi, I have my tempDB growing (data file reaching 6 Giga, log file is small). I use heavily temporary tables, ont he same box I have BizTalk server and Commerce server. So there is a lot of activity on the box. ...
Trace is turned on by default in SQL2k5 RTM
andsm -
17 Nov 2005 2:27 PM - 4 messages
I downloaded SQL2k5 RTM Developer Edition, from msdn subscribtion, at end of October. Today I started to do performance comparison between SQL2k and SQL2k5. SQL2k5 had very bad results. After some investigation, I found what 'default trace enabled' was turned on. So it wrote trace logs to disk and it ...
SQL2005 to manage SQL2000 systems
__Stephen -
17 Nov 2005 2:21 PM - 9 messages
I have installed the new version on my desktop, and found that I can mange my older db's on my local box as well as the newer ones I just created in testing. Is there a back slap if I start to manage dev and test systems using the ...
2000 SP4 stops auto checkpointing - fixed by sql restart
news.microsoft.com -
17 Nov 2005 2:11 PM - 4 messages
We have realised that this is happening from time to time. Our log "in use" starts growing. We then have to start issuing manual (by job) checkpoints every 15 mins. If we restart sql server then auto checkpoints start working again for the ...
Tool to execute more scripts
MV -
17 Nov 2005 2:01 PM - 2 messages
Hi, as Application tester, I need to run a lot of small/medium size .sql file with Query Analyser at once. I would ask if somebody know a tool or another way to execute the script togheter, instead of open/run all single ...
Intel processor identifier tool, where is it?
Jéjé -
17 Nov 2005 1:42 PM - 6 messages
Hi, I have lost the link where there is a tool to identify the processors in my server. to identify which one is the physical and which one is the HT. any one can help me? thanks. Jerome. ...
[Newbie] Restoring.............
Erland -
17 Nov 2005 1:28 PM - 3 messages
Hi, I am very new to Microsoft Technologies, infact new to database world restore this backup by using SQL-Server 2000Enterprise edition, how should i go about it? Any help or comments will be highly appreciated. -Erland ...
d99_tmp table?
twlancer -
17 Nov 2005 12:22 PM - 11 messages
i noticed a table named 'd99_tmp' appeared in one of my SQL db from nowhere. the fields are 'subdirectory', 'dept' and 'file'. And it contains info about my server harddisk file information. Does anyone knows where this table comes from? ...
an interesting problem
John -
17 Nov 2005 12:01 PM - 5 messages
I manage a news database oriented website where there is a column named 'news' in a table 'news' storing huge HTML formatted artciles. I had to replace a particular word 'india' by 'world' in all the records under this column. Strange thing is the occurances of the word 'india' towards the end ...
Potential issues with backing up to a network share
Oskar -
17 Nov 2005 10:56 AM - 2 messages
Hi What potential issues can you think of or have run into when making transaction log backups into a single file on a network share. The MSSQLSERVER service is running under a domain user account, which has apropriate permissions on the shared folder. The backup is made from a ...
AMD Opteron 64 & SQL 2000 32 bit
Jan -
17 Nov 2005 9:01 AM - 2 messages
Are there any known issues with the AMD Opteron 200 Series running Windows 2003 Ent. Edition and SQL 2000 Ent in a cluster? In a few threads I have seen remarks that SP 4 is needed, but in the feature ...
Grid results in Management Studio
Steen Persson (DK) -
17 Nov 2005 8:34 AM - 4 messages
Hi When I run a query in Management Studio, I get this message - The query has exceeded the maximum number of result sets that can be displayed in the results grid. Only the first 100 result sets are displayed in the grid. ...
Issues with Un-Installng and Re-Installing SQL Server 2005
moondaddy -
17 Nov 2005 8:00 AM - 2 messages
Are there any issues with un-installing and re-installing sql server 2005 dev edition? I think it installed SSRS. I know that un-installing and re-installing sql server 2000 is pretty painless as I've done it many times ...
SQLAgent job stalls
Rukmani -
17 Nov 2005 7:08 AM - 7 messages
We are running SQL2K SP3 on W2K server. We have many jobs scheduled through SQLAgent. One particular TSQL job TSQL job sis cheduled to run every minute. The job itself takes 0.1 to 0.3 seconds to finish (as reported through Job ...
Very large rows in SQL Server
Alistair Speirs -
17 Nov 2005 6:37 AM - 8 messages
Hi, I have inherited a database with a fairly nasty table, full of varchar(8000)s. When rows larger than 8060 attempt to be added to the table it causes an error (rightly so). However, after adding some new varchar columns to the table (that did ...
Many-to-Many Self Joins ?
Simon Shutter -
17 Nov 2005 4:42 AM - 4 messages
Hi Folks, I need to implement a many-to-many self join for a table of acronyms ie each acronym may _reference_ one or more other acronyms and, in addition, each acronym may _be referenced by_ one or more other acronyms. I tried to ...
logins question
-00Eric Clapton -
17 Nov 2005 3:55 AM - 5 messages
I have a list of user login in xls. How can I add them to SQL 2000 logins other than manually input one by one? Thanks. ...
Newbie *easy/stupid?* question
Kristen -
17 Nov 2005 12:41 AM - 2 messages
Hi everyone, I'm just learning sql and I'm trying to do the following to the pubs database: For each order that include the books with title_id PC1035 or BU1032, list the order number, order date, along with title_id, title, and a quantity of ...
SQL 2005 Std Ed memory usage
Steve Wolford -
16 Nov 2005 11:53 PM - 3 messages
The SQL Server 2005 Features Comparison says that the Standard Edtion can use as much RAM as the operating system can support. Are there any special conditions, limitations or settings? Can the Standard Edtion of 2005 really use "unlimited" memory? ...
SET DEADLOCK_PRIORITY in the connection string
Frank Rizzo -
16 Nov 2005 11:52 PM - 2 messages
SET DEADLOCK_PRIORITY command is available to be placed in the stored procedure. Is it possible to pass this information via a connection string by the client app. In other words, I want my connection to always be the deadlock victim, without having to change every stored ...
Errors using sp_refreshview
Brad Ashforth -
16 Nov 2005 11:46 PM - 7 messages
Hi ... I hope someone can explain this. Some time ago we created a stored procedure that loops through all SPs and Views and refreshes them. Yesterday we noticed a problem where two specific views would not refresh (don't seem ...
Database dropdown, Query Analyzer
S -
16 Nov 2005 11:35 PM - 7 messages
I didn't see my previous post in the last half hour, so reposting again. Ok. Whenever I have to switch to a different database in my DEV server, if I click the dropdown box, it takes for ever to show the list of databases on ...
Query Analyzer, Database dropdown
S -
16 Nov 2005 11:26 PM - 2 messages
Not sure where to post this. Thats why reposting in this group. Ok. Whenever I have to switch to a different database in my DEV server, if I click the dropdown box, it takes for ever to show the list of databases on ...
recover with .mdf
cheilig -
16 Nov 2005 10:25 PM - 5 messages
a backup was not made and then the log file was deleted. Is there any way to recover this. ...
Best way to move databse and tlog files from default location
Seth at Sherwood -
16 Nov 2005 10:09 PM - 3 messages
Thanks in advance for all help guys; I need to figure out the best way to move files with no data loss from the default installed location, in my case ms crm database files. When you install MS CRM it does not give you the option if pick an install location of ...
Scan data into SQL Server 2000?
John -
16 Nov 2005 9:27 PM - 4 messages
Hello. Please forgive me if this post is not relative to this newsgroup and if someone could advise which group I should post this in I would appreciate. Does anyone know or have any ideas on recommended software or methods in ...
Data Files and one FileGroup
Rosie -
16 Nov 2005 9:21 PM - 4 messages
Hi, Is it OK if we have one FileGroup but 3 data files in different disk drives? We have a database of size 150G, two data fils are in the same disk drive and the third data file is in a different disk driver. All are in the same ...
SQL 2005 setting up Linked server
Pooja -
16 Nov 2005 7:33 PM - 3 messages
hi, does anyone know how to set up link server onto SQL 2005 server? i need help thanks ...
How to obtain SQL 2005 Developer edition
Richard -
16 Nov 2005 6:53 PM - 4 messages
How can I obtain SQL 2005 Developer edition? ...
Public Role
Robert R via SQLMonster.com -
16 Nov 2005 6:53 PM - 3 messages
In BOL (regarding the Public Role) it states, as one of its functions: "Captures all default permissions for users in a database." How does one assign default permissions for a user? ...
Merge Replication in Enterprise 2005 to Express 2005
david.cornelson -
16 Nov 2005 4:41 PM - 2 messages
I implemented a merge replication publication on a SQL Server 2005 Enterprise instance on a test server. On my laptop I have VS.NET 2005 installed with SQL Server 2005 Express. It's my understanding that I can subscribe to a publication with ...
Pricing and Availability of Developer Edition
RRRSr -
16 Nov 2005 4:33 PM - 3 messages
On the SQL Server site, I find occasional mention of the Developer Edition. However, in the how-to-buy links, I find only mention of the other editions and no mention of the developer edition. How can I find out how to obtain the developer edition? I currently have ...
Service pack 4 performance issues
sqlboy2000 -
16 Nov 2005 3:35 PM - 4 messages
We installed service pack 4 last night on our database server that hosts our financials as well as crm applications. Today performance has gone completely in the toilet. Blocking and deadlocks are occuring all over the place. Indexes were rebuilt and update stats has been run. Is there some step we've ...
SQL Server 2005: Poor performance?
Thomas Hein -
16 Nov 2005 3:33 PM - 2 messages
Hi folks, has anyone else encountered a loss of performance when running the same tests on the same hardware box and just changing from a 2000 instance to a 2005 instance? On 2000 we get 20-30 percent better results... ...
Space Available
cjl -
16 Nov 2005 3:09 PM - 7 messages
In Enterprise Manager for Sql 2000, the property dialog for a database has a space available on it general tab. How is this number calculated? Thanks, CJL ...
Setting up Outlook on SQL server for emailing alerts and reports
Jordan -
16 Nov 2005 2:41 PM - 2 messages
I have a Windows 2003 server running SQL 2000 SP3. I want to start setting up email alerts and reporting on the SQL server. Is Outlook 2003 OK or should I stick with Outlook 2000? If it is relevant, I have an Exchange ...
Triggers, virtual tables, Transaction Log and locking..
Troy -
16 Nov 2005 2:30 PM - 4 messages
Hi, I have a question about using the virtual tables (INSERTED,DELETED) in a trigger. As far as i can read around the net, these two tables are, kind of, views to the transaction log. Now using these virtuale tables in various joins does that lock the ...
Problem copying tables to another server with Primary and Foreign Key constrains
war_wheelan -
16 Nov 2005 2:21 PM - 3 messages
How can I copy a table with a Primary Key to another server's table of the same name without receiving the following error: (Error at Destination for Row number 489. Errors encountered so far in this task:1.The statement has been terminated. Violation of PRIMARY KEY ...
CPU, Physical IO, & Memory Usage
MGeles -
16 Nov 2005 2:20 PM - 2 messages
I was wondering about what the values in Management->Current Activity->Process Info represent. Are the values for CPU, Physical IO, & Memory Usage cumulative or do they represent a max or a current value? The reason I'm wondering is that I saw a large value for Memory Usage by a ...
|
|||||||||||||||||||||||