Filter by Day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28
stored procedure ?
Posted by sklett at 2/7/2006 11:55:07 PM
pretty new to stored procedures. I want to run two select statements, the
first will get the userID, username and password from table_A
The second will get the roles for the above user from the 'users_roles'
table, but i need the UserID value to execute the second SELECT. I thought
it would...more >>
Want to create a database snapshot of one filegroup only
Posted by Nayan Raval at 2/7/2006 9:00:56 PM
Using SQL 2005, my principal database contains many filegroups but I'm only
interested in creating a database snapshot of one of these filegroups.
Specifying only one of the file names in the
CREATE DATABASE databasex_snapshot ... AS SNAPSHOT OF databasex
results in the error
Msg 5127, ...more >>
negative spid number
Posted by Hassan at 2/7/2006 8:49:26 PM
I could have sworn I saw a spid with a negative number .
Am I hallucinating or has anyone seen that before ?
MCP Tests Off MCDBA CD Have Script Errors!
Posted by dthulin NO[at]SPAM gmail.com at 2/7/2006 8:47:30 PM
I decided to become MCDBA certified and bought a book (70-228) that
will help me study for the first test. I pop in one of the CD's it
came with and install the test questions. When I launch the program I
get this: http://img154.imageshack.us/img154/7994/scripterror2zm.jpg
Okay, I click ye...more >>
what datatyp for filesize?
Posted by Marc Bauer at 2/7/2006 8:20:35 PM
maybe a stupid question, but what do you think is the best data type if i
need to save filesizes (in bytes)? i think varchar is not the fastest
solution if i need to calculate some sum statistics about this sizes...
Posted by Dan at 2/7/2006 7:49:44 PM
I have a database that was 7GB. I wanted to shrink the database. In the
Shrink Database screen it showed the free space at 69%. I specified Maximum
free space after shrinking to be 25%. After shrinking it says there is 51%
Does it not shrink it all the way down to 25% free? Should ...more >>
Doubts about SQL-DMO
Posted by Juliano H via SQLMonster.com at 2/7/2006 6:17:58 PM
I've saw many information and commands about SQL-DMO, but I don't know what's
is this and how to use it yet. Could you please explain me how to use and
when is better to use this kind of command?
Message posted via http://www.sqlmonster.com...more >>
send copy of backup file to other server
Posted by dmcmillan at 2/7/2006 5:29:12 PM
I have a maintenace plan set up to backup up the database to disk on the
server, it is later picked up by Veritas and sent to tape. I would also like
to send a copy of the .BAK file to another server. How can I add a step to
the maintenance plan to do that? Thanks very much for any ideas....more >>
Don't see what you're looking for? Search DevelopmentNow.com.
"PRIMARY" filegroup is full
Posted by Dean J Garrett at 2/7/2006 5:04:50 PM
We have an SQL Server app written in ASP that suddenly has an error after 2
years of operation, and we're having trouble locating the problem. Here is
the error message below. The reference in the Knowledgebase for this error
doesn't seem to apply to us. There is plenty of space left...more >>
corruption of database maintenance wizard
Posted by chriske911 at 2/7/2006 3:05:09 PM
when I try to add a job I am unable to use the wizard
the screen that holds the settings is corrupted
I can no longer define how many backups have to stay in the folder
I can set the number but the listbox after that stays empty so I can
not set "hours" or "days"
the job it...more >>
Cannot attach files from different databases?
Posted by KMP at 2/7/2006 2:49:02 PM
Is there any way that SQL Server can be forced to recognise files from 2
different databases? I am thinking that there is some setting in the Master
database that can be changed, like an ID, or a GUID (which matches the file
with their respective databases). If that value can be changed, I thi...more >>
Posted by Rich at 2/7/2006 1:23:27 PM
is there any way to load only the Query Analyzer on a developer's PC. I
have a developer that likes the look and feel of QA but I do not want to load
the Enterprise Manager onto the users PC.
deleting duplicate record
Posted by Johnfli at 2/7/2006 1:14:12 PM
in my table, I have several rows that are complete duplicates. Needless to
say, I can't open the table and just delete 1 row.
How do I delete the copies and not all?
Configuring memory for SQL 2000
Posted by Leon Shargorodsky at 2/7/2006 1:07:27 PM
I'm planning to install SQL Server 2000 Enterprise Edition on Windows Server
2003 Standard Edition machine with 8Gb of memory.
How do I force SQL server to use at least 6Gb out of 8Gb?
Thank you in advance!
reclaim "unused space" from a table?
Posted by cmay at 2/7/2006 12:19:13 PM
We have a table that is showing a large amount of "reserved" space:
Reserved 11255328 KB
Data: 1176296 KB
Index_size: 531240 KB
unused: 9547792 KB
(found wiht sp_spaceused)
We have only simple types in this table... no ntext or blobs or
Just int, small...more >>
tempdb data and log file location
Posted by Sandra at 2/7/2006 12:07:06 PM
Is it better to keep the tempdb data and log file on its own separate drive
(Raid 1+0), or should I keep the tempdb data file on it's own drive and move
the tempdb log file to the drive with all the other log files?
DROP and CREATE INDEXES
Posted by Scott at 2/7/2006 12:06:28 PM
I'm trying to reduce fragmentation of indexes on tables. When I run DBCC
SHOWCONTIG on the table both befor and after dropping and recreating the
indexes, including PK constraints, the results are the same? Any insight? I
thought this would reorganize the data to be more efficient? What am...more >>
DBA - Service Request Form
Posted by Jerry Spivey at 2/7/2006 12:01:15 PM
I'm looking to implement a paper-based service request form for all DBA
related activities i.e., adding logins, users, tables etc... granting
permissions, dropping objects, etc... Does anyone have a link to an online
form that I can start with or have an in-house form (.doc) that I ca...more >>
DTS will not send attachment using sp_send_cdosysmail
Posted by ChrisP at 2/7/2006 11:47:26 AM
I have created a DTS that exports the results of a query to an excel
sheet and the delivers the xls to a group of users.
The DTS will send the the email but not the attachment; however, if I
execute the same statement using QA, the attachment works fine. I have
the DTS authenticating to the loc...more >>
Changing FQDN on SQL Server 2K
Posted by Bryan.S.Walker at 2/7/2006 11:05:28 AM
Can anybody shed some light on what I might run into when the FQDN is changed
on SQL Server 2K? We are currently in the process of migrating several
domains into a single .NET domain and there are several SQL Server 2K systems
that will be changed. Researching this I have been seeing a lot of ...more >>
Outlook 2003 does not work with SQL Mail !!
Posted by fredscuba at 2/7/2006 10:51:28 AM
It would appear that Outlook 2003 (and 2002) does not work with SQL Mail,
unless you are using an Exchange Server. The SQL Mail program and Outlook
2003 *BOTH* try to open the Personal Folder file (.pst file) and one of them
If I close the Outlook 2003 client, SQL Mail works fine, ex...more >>
SQL2005 64bit shrink file - Log file is 12GB
Posted by SangHunJung at 2/7/2006 10:07:27 AM
I have SQL2005 64bit running on Win 2003 Itenium server. One of database is
about 18 GB. Data file is 4 GB which is fine but the log file is 12 GB. I
have run full backup nightly and run a Log backup at lunch time daily basis.
** Background **
This database is not being used mush ...more >>
QUOTED_IDENTIFIER and ARITHABORT for Maintenance plans
Posted by helpplease at 2/7/2006 10:03:27 AM
I would like to setup a maintenance job to 'Rebuild Indexes' as my
'Optimization Job' keeps failing on "DBCC failed because the following set
options have incorrect settings: 'QUOTED_IDENTIFIER, ARITHABORT'.
What command do I need to use to rebuild all the indexes on all the tables.
Detach/Attach to SQL Server 2005
Posted by sck10 at 2/7/2006 9:58:35 AM
We have two developer machines. One is running SS2K and the other is
running SS2005. What we want to do is detach a SS2K database, copy it and
then put it on the other machine and attached it to SS2005. When I attach
the database, will it automatically be upgraded to a 2005 type data...more >>
Seeing SQLDMO in Profiler
Posted by MANCPOLYMAN at 2/7/2006 9:33:29 AM
I'm running profiler on databases that I thought were no longer being used.
However I see a couple of lines in the profiler that have as application
My understanding of SQLDMO is very sketchy but is it a central connection
used to access the dataabses rather than a specific nam...more >>
log in MSSQL\Data\MSSQL\Data
Posted by gd at 2/7/2006 9:11:28 AM
we have a log in MSSQL\Data\MSSQL\Data\dm_Enterprise20050526161738_log1
that is over 50 Gig. Can someone tell me wht this log is? also we re-boot
on the weekends, so if this log gets cleared after a reboot how could it grow
so fast in 2 days?
thanks for any help...more >>
need to write query...
Posted by uspensky NO[at]SPAM gmail.com at 2/7/2006 8:50:57 AM
need to write query...
need to display report of names ordered by total score descending only
if total is above 0 so re...more >>
Installing SQL Server 2005
Posted by sck10 at 2/7/2006 8:41:42 AM
I have SQL Server 2000 on my machine and just installed SQL Server 2005 but
my registered server on my local machine still reads MyServer (SQL Server
8.0.760- MyServer\drake). Can I have two registrations on my local machine
using Windows Authentication. One for the old version and on...more >>
Moving data from SQL Server to Access
Posted by ianthomasfletcher NO[at]SPAM gmail.com at 2/7/2006 8:19:00 AM
Could anyone please offer advice on the following:
I have a table in a SQL Server database, that I would like to put a
trigger on. When an Insert is ran on the table, I would like to also
run an insert on an Access database. The Access database is not on the
same server, but is on a networke...more >>
Memory Usage per DB-Instance
Posted by NickD at 2/7/2006 7:47:27 AM
I'm using SQL 2000 Standard and Windows 2000 Server Standard on one server
machine. Ther real RAM is 3,25GB. I'm using TWO DB-instances.
My question is, how much memory can I allocate (reserve) per instance?
Due to limitations in 2000 Standard Server i cannot use parameters like
Removing case sensitivity
Posted by jaylou at 2/7/2006 7:31:30 AM
Is there a way to remove Case Sensitivity from a SQL 2000 server? I can't
imagine why anyone would set the server to this but one of my vendors did and
I hate needing to know exactly where to put my caps....
Person.Coontact - AdventureWorks
Posted by farshad at 2/7/2006 7:05:29 AM
I have the AdventureWorks database in sql server 2005.
The Table Person.Contact is empty. I have the .csv file for the data for
this table. This .csv seems to be xml data.
How can I get this particular .csv into this table?
I basically would like to somehow populate this particular table.
Posted by ProCom at 2/7/2006 7:02:45 AM
I am trying to add a backup device to SQL that will use our NAS. When I enter
the UNC \\ProCom-SERVER\BACKUP\DISK.BAK for the file location I get a message
that SQL Server can not verify the existenance of the backup file location.
The path \\PROCOM-SERVER\BACKUP exist and I use it for other b...more >>
Posted by Mumbai_Chef at 2/7/2006 6:31:29 AM
I get the following error when I try to connect to SQL 2005 Beta from VS 2005.
"A connection was successfully established with the server, but then an
error occurred during the login process. (provider: TCP Provider, error: 0 -
An existing connection was forcibly closed by the remote h...more >>
sql server 2005 partition query
Posted by ccote_msl NO[at]SPAM yahoo.com at 2/7/2006 5:55:10 AM
HI, I am coming from an Oracle world. I would like to know if it is
possible to use a specific partition name or number in SQL 2005 like we
FROM MyPartitionedTable PARTITION(PartitionName)
Let's say that MyPartitionedTable is partitionned by months, I...more >>
Index Fill Ratio
Posted by Ehab ELGEDDAWY at 2/7/2006 5:49:31 AM
Iâ€™m trying to copy a very large amount of data about 10,000,000 records from
one table to another using DTS. And while Iâ€™m doing the task although I can
select data from the destination table using the sql query analyzer, I canâ€™t
execute the same select statement using ADO connection th...more >>
How to create Logs?
Posted by iice at 2/7/2006 2:02:27 AM
Can anyone please tell me where and how to configure SQL log files. I am a
Network Admin person and don't know anything in SQL....more >>
Change the server date and time
Posted by SouRa at 2/7/2006 12:58:29 AM
can you tell me, how to change the server date and time using queries.
Please advise me.
My MDF Files currupted
Posted by khandelwal.deep NO[at]SPAM gmail.com at 2/7/2006 12:57:54 AM
My company have server with loads of test databases. last saturday its
hard disk crashed all the partitions were lost . i tried to recover
data from that disk and found my database folder. I took backup on
another harddisk and tried to attache my databases but sql server says
it not avalid datab...more >>
"ImpersonateClient" property in Yukon
Posted by Prasad at 2/7/2006 12:00:00 AM
Does anybody knows how to get the value for "ImpersonateClient" property
which is on IntegratedSecurity Object in SQL - DMO for SQL Server 2005
Documentation says that the functionality has been moved to "Server
Connection" class of SMO but I couldnt find the property th...more >>
Viewing Stored Procedure
Posted by Chris at 2/7/2006 12:00:00 AM
I have an sql server hosted externally. I want to view some of the stored
procedures in a similar way to query analyser where you right click on the
stored procedure select alter and you can see the stored procdure. I want to
do this online. How do I get the stored procedure and what permissio...more >>
SQL 2005 Architecture Question - Active Secondary Database?
Posted by Calculated at 2/7/2006 12:00:00 AM
We are going Live with a large project at the end of the month. There is
a primary server for the OLTP section and an additonal server for the
users to run reports against a copy of the Live database. Fair enough.
The machines are both very well specced for the amount of users the
system wil...more >>
alter user defined data type length
Posted by Vikram at 2/7/2006 12:00:00 AM
I have one UDD, which is used in some tables.
Now i want to change its length. How can i do that ?