|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
SQL Server database programmingmicrosoft.public.sqlserver.programming
set datefield default to a specific date
GTN170777 -
4 Feb 2006 11:23 PM - 6 messages
Hi all, I would be really grateful for your assistance with this. I need to set the default value od a date field to a specific date - in this instance the date would be 01/06/2006. Is there any code that will do this? ...
Automatic record counter in MS-SQL
Andrew Chalk -
4 Feb 2006 10:35 PM - 4 messages
Is there any kind of automatic record counter in MS SQL 2005 that can be used to reference a record one is updating? Many thanks ...
Query - pop-up menu for user data entry
ROY A. DAY -
4 Feb 2006 9:15 PM - 2 messages
Using the following syntax: Select fname, lastn From list Where fname like 'jones' I need the syntax that the user can enter a name to perform a query (the user will enter a name on a pop-up menu before the query is performed). ...
query performance
Jim Abel -
4 Feb 2006 8:23 PM - 4 messages
The folling query works but is it the most efficient way to write it from a performance aspect? The parameter can be set with the values (0,1 and %) these can be changed if needed for the final query version. ...
How do I suppress MS SQL result information
Abu Bilal -
4 Feb 2006 6:33 PM - 3 messages
I am trying to get a resutlt for executing a statement in SQL Query Analyzer. How do I suppress '(1 row(s) affecte)' message from the result I get when executing a select statement. When I want to execute the following statement: ...
Ranking Functions: ROW_NUMBER() Performance
Eyal -
4 Feb 2006 6:01 PM - 5 messages
Hello all. I have a question about Ranking Functions in SQL 2005, namely the ROW_NUMBER() function commenly used in CTEs. According to a Microsoft white paper I read, the ROW_NUMBER() function runs through the table and "Stores" the matching rows along with a position ...
Qualifing table names with dbo
Jim Abel -
4 Feb 2006 4:13 PM - 21 messages
I see different examples of query statements some with the table names preceeded by dbo.tablename and others with only the table name. Does the dbo do anything at all, especially if the user that request the query to execute ...
Help - Simple DataGrid Problem in Vis. Studio 2003
thebison -
4 Feb 2006 3:21 PM - 2 messages
Hi, As a relative newbie to SQL Server/ASP.NET I'm hoping someone here can help with my problem. I'm developing a timesheet application in ASP.NET C# using Visual Studio 2003 with a database built in MSDE. ...
Look for differences
Thom Anderson -
4 Feb 2006 2:44 PM - 4 messages
We get a daily file from a vendor that may or may not contain changes in one or many columns. Is there some kind of easy way to check for a difference between their feed and what we have on the table? Note, there is no "last ...
1 database, 2 threads
Roger Garrett -
4 Feb 2006 12:57 PM - 6 messages
I'm doing some queries on a SQL Server 2000 database. (MFC C++ dialog-based application). I start up a transaction with: m_Session.StartTransaction(ISOLATIONLEVEL_SERIALIZABLE) I then do a query that determines whether or not a particular item is in a ...
using crystal reports
praba -
4 Feb 2006 12:23 PM - 1 message
Hi, I have .net framework on my server. i have create an web application .aspx page i want to include crystal reports on my project. How can i use crystal reports in web application using .net ...
linked server problem on SQL Server 2000 sp3
Bassam -
4 Feb 2006 10:43 AM - 4 messages
Hello im trying to connect to a remote server over an internet vpn connection i asked admin of the remote location to open port 1433 in his firewall, he did and im able to register the server successfully by IP address on ...
Group By (part of a field)
Gérard Leclercq -
4 Feb 2006 8:21 AM - 5 messages
In my tables there are fields for Make, Model, Type, Cc, Carburant, Etc... But for a unknown reason, maybe laziness, my users fill in all data in Model. How can i Group on the text before the first space i like to Group. ...
Stored procedures, nullable parameters, COALESCE
Mark Rae -
4 Feb 2006 8:16 AM - 24 messages
Hi, A while ago, I found an article on the web which demonstrated the ability to create stored procedures with nullable parameters and the COALESCE function. E.g. CREATE PROC TestSelect @CustomerID int = NULL AS SELECT * FROM Customers ...
Putting SQL Artifacts Into Source Code Control
Will -
4 Feb 2006 5:42 AM - 4 messages
What are the best options for putting SQL Server artifacts like triggers into source code control, and then automating moving the objects from human readable files back into the database as triggers? Are any of the good options cheap? ...
I want to store file's data into data base using MFC
patel.shoaib -
4 Feb 2006 4:15 AM - 1 message
Hello Friends,Ok let me directly come to point Iam a new bird into this forest, so plz help me Iam given a task to accept file name from user (I did using CFileDialog class,Open dialog) now store this files data into MSSQL DB ...
Query Question ...
Randy -
4 Feb 2006 1:00 AM - 3 messages
I have a Client table with a province code and an amount. Is there anyway to return 1 row for each client that contains the amounts for each province without a subselect ? Clt Amt1 Amt2 Amt3 ...
SQLDEvPRO What Happened to Aaron Goldman
shoeman -
4 Feb 2006 12:59 AM - 2 messages
Does anyone know what happened to these people. Against my better judgement I bought a version of SQLDevpro in spite of it having the kind of copy protection that makes you go cap in hand to the developer for a new key ...
Counting in Self Joins
Paul -
4 Feb 2006 12:22 AM - 4 messages
I have a view that contains a self join: SELECT dbo.Clients1.ClientID, dbo.Clients1.AccountName, dbo.Clients1.OwnedByClientID, Clients1_1.AccountName AS OwnedByClientName ...
Isolation levels and SELECT's (even when using SERIALIZABLE!)
JBilger -
3 Feb 2006 11:54 PM - 4 messages
I thought that it would be interesting to point out some very subtle issues that can occur when using SELECT's inside a transaction that also includes INSERTS/UPDATES or DELETES.). The issues really arise when concurrency occurs (ie many users trying to execute this ...
Naming Conventions: Prefixing Columns w/ Table Names
Jerad Rose -
3 Feb 2006 11:03 PM - 50 messages
I know this is a heavily debated topic, and I know many times it's totally subjective and up to personal preferences. But I want to bring up a discussion that I've yet to see covered. When building column names, I'm trying to find out what pros/cons are to ...
Help with triggers
Matthew -
3 Feb 2006 10:28 PM - 3 messages
For security reasons I am trying to develop a trigger that is capable of sensing data and then running a process. The idea is to only allow internal processing and not have to grant access to the entire database to run a process. ...
cascade delete ...
kazoo -
3 Feb 2006 10:27 PM - 2 messages
Hi! I have a question about implementing cascade deletes in sql server 2000 database. I have two tables: Object (ObjectId, ObjectName, ObjectType, etc.) Object_Association (ObjectParentId, ObjectId) Both fields in the association table are foreign key related to the ObjectId field in the first table. I would like the cascade delete on ...
Lost Trigger
Mark Stewart -
3 Feb 2006 8:51 PM - 9 messages
Hi I created a trigger and now it is missing. When I run Create Trigger Customer_Update on Customers routine it says there is already a procedure by that name however I have searched and searched to edit or remove this trigger and I cannot find it. ...
@@RowCount
td -
3 Feb 2006 8:39 PM - 8 messages
I want to run one of two SELECT statements, one with a Join the other without, depending on wheteher the Join fails because of an unrelated record. The second statement should always return one row as the @RequestID value being passed comes from a Tree selection. But no row is returned. Where am I ...
design question : the sub-entities cohesion problem
before.the.gods -
3 Feb 2006 8:29 PM - 6 messages
Hello, I am in the process of designing a big commercial database for a wholesaler. Since many months now, I have been asking myself questions about how to physically implement a system of tables that would efficiently represent the logical situation of many "sub-entities" related to a ...
Question about Converting Crystal syntax into SQL or VB
jennifer.rodgers@fidessa.com -
3 Feb 2006 8:23 PM - 2 messages
I'm having an issue with a date field in Access. I have imported data from a database and the date field is a HUGE number rather than an actual date. I have a formula from crystal reports to convert the ...
2005 Create new instance, replace sqlexpress
rvgrahamsevatenein -
3 Feb 2006 7:53 PM - 4 messages
I had installed Sql Express on my machine, now i have Visual Studio Pro 2005 which came with Sql Server 2005 Developer edition. I carefully uninstalled anything I could find that was related to the express edition before installing Developer. But still when I try to connect in ...
comparible match for numbers similer to Like and %
Jim Abel -
3 Feb 2006 7:05 PM - 3 messages
Is ther a character that can be used yo match numeric datatypes similar to the Like keyword and the % cbaracter? I want to us a parameter that is a bit type and return records that true false or both. In the WHERE clause I can get either true or false ...
Need help grouping by year
johngilmer -
3 Feb 2006 7:03 PM - 4 messages
I have a table of patients. There's a date column called AdmitDate. So if I want to know the number of patients that were admitted in each year, I can do: SELECT DATENAME([year], AdmitDate) AS 'Year', COUNT(*) AS ...
Stats in backup / restore
quilkin -
3 Feb 2006 6:59 PM - 6 messages
Where do I find the STATS output from Backup or restore operations when these are called programmatically? SQL books says "Displays a message each time another percentage completes and is used to gauge progress." - but where can I find that message, so I can use it to update a progress bar? Is a file ...
Group By
Gérard Leclercq -
3 Feb 2006 6:32 PM - 7 messages
I want to retrieve the model of cars in Groups. However the field Model is filled with the model and the type. Is there a way to group on the first word, lets say 147, 156, .. Thx GL 147 1.9 D ...
Generating an SQL script for a DTS Package
stjulian -
3 Feb 2006 6:11 PM - 2 messages
Can an SQL script be generated for a DTS package? I need to be able to create script to recreate every object that relates to the normal functioning of the database. Most other objects are easy to get an executable script to recreate. I can't seem to figure this one out. ...
@@Error and @@RowCount
Rajesh -
3 Feb 2006 5:51 PM - 3 messages
DECLARE @ErrorNum INT , @RowCount INT DELETE Seller WHERE SellerId = 9999999999999 SELECT @ErrorNum = @@ERROR , @RowCount = @@ROWCOUNT SELECT @RowCount , @ErrorNum ...
Generate foreign key's DROP by ScriptTransfer
Hans Ruck 2 -
3 Feb 2006 5:22 PM - 1 message
Hello all, I'm trying to generate the SQL scripts of a database automatically by the use of the "ScriptTransfer" method of the "Database2" class. It would have been nice if the DROP commands would be generated for the foreign keys too but, so far, it seems impossible. I've been playing ...
high-speed insert
Larry -
3 Feb 2006 5:13 PM - 3 messages
I have been using an OODB as the repository for a stock-quote ticker plant. I would love to be able to convert this to SQL Server. Quotes come in at a nominal rate of 10K per second with peaks up to 60K. ...
Delete large amount of records
mecn -
3 Feb 2006 4:55 PM - 3 messages
Hi, I need to delete large amount of record from sql2k table weekly. My question is that there is any way that I could delete them pypassing sql log file. Delete * from table1 where year(createdate) < '02' Thanks, ...
Return Related ID filed in MIN() Function
Michael Mach -
3 Feb 2006 4:45 PM - 2 messages
I have the following. CREATE TABLE Assessment ( AssessmentKey int Primary identity(1,1), AssessmentType int, AssessmentDate datetime ...
Deadlock on SQL SELECT statement
bigcoops -
3 Feb 2006 4:10 PM - 6 messages
I have inherited the maintenance of a product which includes the snipet of code below. Every 10 seconds the code is executed. It is causing a deadlock in some instances, but I am undable to reproduce the problem ...
Connecting to SQL Server 2000 on Windows 2003 Server using sql-dmo
Brian Nielsen -
3 Feb 2006 4:10 PM - 2 messages
Hi I have a strange problem connecting to a local SQL Server 2000 on a machine running Windows 2003 Server. I'm using a plain connection as shown in the code below: Dim oServer as New SQLDMO.SQLServer With oServer ...
Importing csv File into SqlExpress .MDF file.
tom.herz -
3 Feb 2006 4:05 PM - 3 messages
Hi, I'm trying to use BCP to import a .csv file into a .mdf file. At the commandline, I'm using the following command: bcp commercedb.mdf.crmc_products in test.csv -T I'm getting errors (below) telling me that I'm not successfully ...
CLR function slow down with lilke statement
Romain TOUTAIN -
3 Feb 2006 3:57 PM - 1 message
Hi, I programmed a small & simple assembly using c# in order to remove unwanted letters from a word and exclude unwanted sords. for example : Select * from t_products where lib_product = Compact('THIS IS THE SENTENCE) All works fine, but when i use this query : ...
UPDATE values in a table with values from another table
Paul -
3 Feb 2006 3:55 PM - 4 messages
How can one update the values of one column from the values with the values the column of another table? For example, I have two tables, Customers and Invoices. The customer table has an identity column CustomerID, and a Col. CustomerName associated with ...
pass thru queries to Oracle
arch -
3 Feb 2006 2:56 PM - 4 messages
I'm trying to pass a query from sql server 2000 to Oracle using linked servers. I don't want to use DTS. While it's easy enough to use OPENQUERY to pass thru a query that returns a dataset, I can't seem to pass thru a ...
UDT - how do i drop my type in sql server 2005
Learner -
3 Feb 2006 2:24 PM - 5 messages
Hello , I have created a UDT and depoyed it. Later on again i have chnaged my code and tried to re deploy it and its throwing an error message. When i right click on my project in the solution explorer and click on deploy its throwing a message saying that ...
alias for variable [memory] table?
mtczx232 -
3 Feb 2006 2:14 PM - 6 messages
i have this sql Q: a delete statement not allowed to use with "as" (delete from table as t where..), so when i need "as" i do it in sub q, like this: delete from customers where 3<(select count(*) from customer t where ...
Complex query
Stijn Verrept -
3 Feb 2006 2:08 PM - 1 message
Hi all, I have absolutely no idea on how to start with this one. I have the following tables: In the table ServiceGrating there are names of gratings defined to work. The times of grating are in the table ServiceTimes. ...
DTSInstall.EXE is not created in my Deployment catalog
Robert Pettersson -
3 Feb 2006 1:56 PM - 1 message
Hi, I have a problem in my SSIS-package. I have created my package and put my connectionstrings in a config file. It works fine when i run it on my local mashine. There are 4 packages in my solution. ...
column info from temp table
helmut woess -
3 Feb 2006 1:53 PM - 10 messages
Hello, i have a stored proc where i create two temp tables with complete equal structure. But the structure is different every time the stored proc is called. Now i want to find all records in temp table 1 which are not in ...
some simple proc help
rbutch@coair.com -
3 Feb 2006 1:08 PM - 3 messages
hey guys very new to sql server - i can take care of the basic CRUD but,i'm not familiar with some of the syntax to handle stuff right in the proc. i've been making multiple round trips to accomplish what i think i should be able to do based on a condition right when im in the procedure itself. so, please bear with me. ...
TSQL - Address cleaning
culam -
3 Feb 2006 12:50 PM - 5 messages
Please help, I need to only select 1 address for each customer_id, address_id is primary key. Thanks in advance, Culam address_id customer_id street_addr_line_1 city_nm ----------- ----------- ---------------------------------------------- 516428 65619 3347 BARONA MESA RD RAMONA ...
Query slow with hardcoded dates
Marty -
3 Feb 2006 12:49 PM - 6 messages
What's going on here ? I had a stored procedure running oddly slow, which I've fixed, but I'd love to know why it was slow in the first place. This query takes 35 seconds to run: Select starttime from tbldata ...
how to specify mail sender when exec xp_sendmail from sql analyze
she -
3 Feb 2006 11:38 AM - 2 messages
When execute xp_sendmail in sql analyzer, is there a way to specify Email sender instead of the default sql mail sender. For example, when I exceute the following code exec xp_sendmail @recipients='y***@some.com' The recipient will only see the mail address from the default sql mail ...
Advance TSQL question
culam -
3 Feb 2006 11:34 AM - 3 messages
Hi, I would like to find customers (same id) with different addresses: Id Address -- ----------- 1 123 ABC 2 456 DEF 1 789 GHI 2 456 DEF ...
Oracle MINUS equivalent in MSSQL2000 ?
helmut woess -
3 Feb 2006 11:32 AM - 12 messages
Hello, has somebody a tip how to make the Oracle-MINUS with SQL Server? thanks, Helmut ...
Using VS2003/2005 to write a 2000 Custom DTS Task in C++
Alex Thomas -
3 Feb 2006 11:30 AM - 1 message
I may need to write a Custom DTS Task for SQL Server 2000 to implement FTPS (employing the nsoftware components). The two starting points are a VB6 and and ATL sample. For VB6 I need to use VS6, however for the ATL can I use VS2003 or VS 2005, and if so does anyone ...
special caracters
Xavier -
3 Feb 2006 11:23 AM - 4 messages
hello, i want to find the rows in which field1 did not mach field2 .. (problem with special caracters) i have a table which is a result of a insert ..... In the table are id and 2 fields of type Varchar(50) ...
unique records
Greg Jones -
3 Feb 2006 11:17 AM - 10 messages
I have the following data and I swear I am losing my mind. I want to condense the table below into 3 unique combinations and I am having the worst time on this seemingly simple problem. I don't care which ...
Best Practice
Robert Bravery -
3 Feb 2006 10:43 AM - 5 messages
Hi all, We have a claims table in out database. It has A child table which would hold different financial ammount with regards to the claim loss, eg material dammage, third party, towing etc. Each catergory of loss is a new row. ...
How to Compare Date every day automatically?
savvy -
3 Feb 2006 10:02 AM - 3 messages
I got various Job Details listed in my table. I have set all jobs in a such a way that they will be LIVE when Flag=1 and EXPIRED when Flag=0. But how can I compare the Expiry Job Date with the Current Date and ...
How to list the names of check constraint of a table and how to show it's content?
Frank Lee -
3 Feb 2006 9:26 AM - 3 messages
How to list the names of check constraint of a table? How to show the content of a check constraint? Thanks ---Frank, SQL2005 ...
Executing a DTS package
Reggie -
3 Feb 2006 8:17 AM - 3 messages
Hi and TIA. What I'm trying to do is create a DTS package in SQL Server(2K). What I then want to do is have my users locate the database(Access2K) file, upload the file to a virtual directory, and then ...
wsid() help
rmanchu -
3 Feb 2006 6:43 AM - 4 messages
hi is there a built in function that returns an int that can be set via the connection string? wud prefer to use a single function call that returns an int as this field will be inserted into almost all tables for audit trails. ...
SQL Query - Isolating last row in customer record
Malcolm via SQLMonster.com -
3 Feb 2006 6:20 AM - 3 messages
Hi,, I have a simple MS Access database that contains two tables at present. Customer_Info and Payment_Details. I want to run a query that will give me a list of customers who owe money on their account based on the date in the SQL query. ...
Full Text Search on Encrypted columns
damiensawyer@yahoo.com.au -
3 Feb 2006 5:24 AM - 1 message
Hello all, I'm at the design phase of a project at the moment and have come accross an interesting question. Currently - the project is going to use SQL2000. I am going to have a large number of 'text' fields containing up to ...
Foreign Key from two tables to one?
mahalie -
3 Feb 2006 2:20 AM - 7 messages
I have a table called Employee_Bios with the following: Bio_ID Employee_ID Bio_Text The Employee_ID comes from one of two tables...the Employees_Active or the Employees_Inactive table. So I have a multi-part question...I know, this is SQL 101 - maybe y'all ...
UDT in SQL server 2005 need help
Learner -
3 Feb 2006 2:06 AM - 3 messages
Hi there, I have created a UDT using in VS2005 and below is my code for the UDT **************************************UDT***************************** Imports System Imports System.Data Imports System.Data.SqlClient Imports System.Data.SqlTypes Imports Microsoft.SqlServer.Server <Serializable()> _ ...
Running low on drive space frequently.
Matthew -
3 Feb 2006 12:42 AM - 3 messages
Is there a way for SQL to alert me when any of the drive spaces on the server become too low? I am sure that someone has a scheduled jobs that does this and would send out e-mails to notify someone. ...
Pintable with full-text search
DonSQL2222 -
2 Feb 2006 10:56 PM - 2 messages
Can you have a pintable and use a full-text search designed table? Thanks, Don ...
Can a CASE Staement be used in the WHERE clause
Jim Abel -
2 Feb 2006 10:01 PM - 7 messages
I have confused myself and need some help clarifing how to weite the following statement so that 3 difierent results can come from the value of the passed Parameter. The parameter can have 0,1 or 2 as the values ...
Recurring Sequence Help
Doug Abrahamson -
2 Feb 2006 10:01 PM - 9 messages
I have a table that contains a date/time column and an integer column. I write to this table every 6 seconds. I am recording the datetime and a current phase (1-5) throughout the day. I want to query the table and list ...
Encryption question
mvp -
2 Feb 2006 9:33 PM - 11 messages
Hello Everybody, I have a Encryption - Decription Question. In my project we are getting an XML File from a vendor which has a credit card number in clear text. We use XML bulk load process to load table from ...
Problem with Bulk Upload. Uploads twice.
meverts -
2 Feb 2006 9:10 PM - 5 messages
When I run the following stored procedure I get these results. My file has 24 rows in it. However I am uploading it twice for some reason. Stored Procedure: CREATE PROCEDURE [dbo].[dsp_Manual_Import] ...
ORDER BY in a SP
andrew -
2 Feb 2006 9:09 PM - 3 messages
I'm getting a little frustrated... I'm trying to write a stored proc... the following code works fine on its own in Query Analyzer... when I put it into my stored proc... SQL Server complains about the ORDERS BY clause. ...
Search for a field within an SP
Mark -
2 Feb 2006 8:50 PM - 4 messages
Hi - I am trying to use DTS (from EM) to copy tables, SPs and data from my remote SQL Server (2000) to my local copy. However, it keeps failing when I try with the SPs - and I think it's ...
Best practice BIT or SET('no','yes') ?
Lisa Pearlson -
2 Feb 2006 8:23 PM - 15 messages
Hi, I know it's quite common to use BIT fields for boolean values. CREATE TABLE tblTest ( door BIT DEFAULT 0, accept BIT DEFAULT 0 ) instead of: CREATE TABLE tblTest ( door SET('close','open') DEFAULT 'close', ...
Composite Index and Query Optimizer
Meher -
2 Feb 2006 8:20 PM - 3 messages
Hi I have a question. If I have a composite primary key on table (in essence I will have a composite clustered index as PK by default creates a clustered index) when would the Query optimzer would not use the index on it?. Is it ...
nvarchar(max) equivalent in C#
skg -
2 Feb 2006 8:03 PM - 9 messages
i am writing a UDF which takes nvarchar(max) as input parameter. Can any one tell me what is the equivalent of this data type in C#. Thx ...
database object hierarchy
GB -
2 Feb 2006 8:02 PM - 8 messages
Hello: In my SQL Server databases I have complex related tables and views. There is any tool which allow you to see (print) this complex hierarchy of views and tables as hierarchical tree? Thanks, GB ...
How are views used each time it is requested.
CD -
2 Feb 2006 7:55 PM - 4 messages
Taking the view below, is a view reran each time it is requested or is there some sort of caching that would hold the dataset ready for the next request of the view? CREATE VIEW dbo.vwTodaysNeurologyAppts AS SELECT TOP 100 PERCENT PatientName, ResourceCode, ApptDate, ActivityType ...
will a client application using ado.net get an exception if the command is executing a stored proced
Daniel -
2 Feb 2006 7:11 PM - 2 messages
will a client application using ado.net get an exception if the command is executing a stored procedure that does a RAISEERROR in its tsql? ...
Disable Trigger Question
Rich -
2 Feb 2006 7:04 PM - 8 messages
Here is a trigger in a table that I am working on. Call it tbl1. AT the bottom of the trigger is an Alter Table statement which looks like it disables the trigger. My question is for the purpose of this Alter Table ...
How can you prevent the data changes message during editing a row
Oliver -
2 Feb 2006 6:33 PM - 8 messages
I just upsized my Access application (mail-order processing system) and linked to SQL server 2000 via ODBC tables links from an Access 2000 front end. By doing so the standard optimistic locking of SQL server 2000 comes into force and the option "lock edited record" on the Access Client gets ignored. ...
Moving data thru linked server
culam -
2 Feb 2006 5:55 PM - 3 messages
We are currently moving data using stored procedures and Linked server. However it takes too long (40 minutes for 600K records with 40 fields). I am hoping to shorten the time. Any suggestion would be appreciated. Example stored procedure: ...
problem with SP to return last @@Identity
Rich -
2 Feb 2006 5:45 PM - 6 messages
I need to retun the last inserted Identity value. - The SP below has a syntax error on the Set line. How can I fix it? create procedure stp_GetIdentity @e int output as SET NOCOUNT ON Set @e = Select @@Identity ...
How do I know if my sql server needs more memroy ?
MO -
2 Feb 2006 5:27 PM - 5 messages
Hi, We have an OLTP system with 600+ connections, 30 gb database running on a 4 CPU and 4.2gb memory, out of which 3.5 gb is allocated to SQL Server (using fixed memory). SQL Server is on its own dedicated machine. ...
trying to group by day without splitting day out in the select list
jason -
2 Feb 2006 5:16 PM - 6 messages
given a simplified table like so: create table transactions ( transactionid uniqueidentifier primary key not null, datecreated datetime default current_timestamp /* just for you celko */ not null) go this query works: select datepart(month, t.datecreated), datepart(day, t.datecreated), datepart(year, t.datecreated), ...
SQL2005 CLR Framework
skg -
2 Feb 2006 4:49 PM - 1 message
We have sql2005 64 bit and framework 2.0 32 and 64 bit. When i try to deploy a UDF 64 bit assembly via vs.net2005 i get following error. Error: Attempted to load a 64-bit assembly on a 32-bit platform. Use ReflectionOnlyLoad() instead if trying to load for reflection purposes. ...
T-sql
topdog -
2 Feb 2006 4:38 PM - 1 message
We are networking to try and fill a position with our company in the dallas tx area. if anyone has any ideas of resources we can use locally to fill this position I'd love any help you can offer. We ...
Function for Determining Completion Time
Will Asrari -
2 Feb 2006 4:24 PM - 3 messages
The company I work for uses tracking software for entering help desk (IT-related) issues. The issues is timestamped and assigned a Priority level (A-D). Each level relates to an estimated completion time. What I'm trying to accomplish is to add the estimated completion time to the ...
checkpoint
Alex -
2 Feb 2006 4:08 PM - 8 messages
Hi friends, I came across the recommendation to do checkpoint to flush a buffer pool out when doing massive modification in small chunks under simple recovery mode. Can someone elaborate a bit more on it? Is it reasonable? And why? ...
Is "SQL Server Management Studio" an OLE Automation Server?
Frank Lee -
2 Feb 2006 3:44 PM - 3 messages
Is "SQL Server Management Studio" an OLE Automation Server? If so, I would like to control it. Thanks. ---Frank ...
Can I use dynamic SQL in a stored procedure to call another stored
Rajendra -
2 Feb 2006 3:31 PM - 3 messages
Hi, I am having one stored procedure named SP1 which is having one input and one output parameter as follows CREATE PROCEDURE dbo.SP1 @xmldoc TEXT ,@FLAG_EXEC VARCHAR(5) AS BEGIN ..... END I have write another stored procedure named SP2 which is creating a dynamic ...
ntext field is blank after insertion,all other fields are populate
Gavin Sullivan -
2 Feb 2006 3:28 PM - 1 message
Hi, We have a simple Stored Procedure to persist some data, one of the fields is an ntext field. When we execute it all the fields bar the ntext one get populated. The ExecuteNonQuery method (ADO.Net 1.1) returns -1. The ntext ...
Namespace
Alan -
2 Feb 2006 3:28 PM - 2 messages
Hello, I have le following c# procedure: namespace AXRON.SqlServer { public partial class StoredProcedures { [Microsoft.SqlServer.Server.SqlProcedure] public static void pSoloDldCreateTables() ...
SQLServer Express Service Fails to Start
Jay Pondy -
2 Feb 2006 3:13 PM - 1 message
I'm getting the following message in the event log: initerrlog: Could not open error log file 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG'. Operating system error = 5(Access is denied.). The service is set up to run under: NT AUTHORITY\NetworkService ...
getting dates between start date and end date
Mike P -
2 Feb 2006 3:05 PM - 11 messages
I have two fields of type datetime - a DateStart field and a DateEnd field. Is it possible to use some SQL to return each of the dates between these 2 dates? Thanks *** Sent via Developersdex [link] *** ...
|
|||||||||||||||||||||||
