Stupid Timing Question
Jan 12, 2007
Hopefully, this is an easy. Does SQL Server use the Windows system date
and time? Or does it keep track of what day/time it is on its own?
We were just discussing this in the office today, because we're
planning for the changes in Daylight Savings Time in the United States
this year. It's going to start a month earlier and end a month later
than it used to. Microsoft is apparently putting out patches for
Windows so the OS will know to adjust the time by an hour on the right
days, and we're trying to determine if our SQL and Oracle databases are
going to be affected at all.
--Richard
View 2 Replies
ADVERTISEMENT
Oct 12, 2001
OK, I did something stupid and now cannot get access to my server...
I was experimenting with the security/login settings and denied access to BUILTINAdministrators. Now I cannot get on my server.
Anyone else ever done this? What can I do to get back on without loosing some of my data?
Any help would be appreciated.
Thanks!
View 1 Replies
View Related
Aug 15, 2006
Still in the world of SAMS Teach Yourself SQL in 24 Hours with SQL 2000. The book says:
CREATE TABLE EMPLOYEE_TBL
(
EMP_IDVARCHAR(9)NOT NULL,
LAST_NAMEVARCHAR(15)NOT NULL,
FIRST_NAMEVARCHAR(15)NOT NULL,
MIDDLE_NAMEVARCHAR(15)NOT NULL,
ADDRESSVARCHAR(30)NOT NULL,
CITYVARCHAR(15)NOT NULL,
STATECHAR(2)NOT NULL,
ZIPINTEGER(5)NOT NULL,
PHONECHAR(10),
PAGERCHAR(10),
CONSTRAINT EMP_PK PRIMARY KEY (EMP_ID)
);
Query Analyser says:
Server: Msg 2716, Level 16, State 1, Line 3
Column or parameter #8: Cannot specify a column width on data type int.
If I take the (5) off the end of the INTEGER data type it runs through but how come you can't specify the width of an integer column?
Ta muchly.
View 6 Replies
View Related
Jun 11, 2008
Hi
I have a query which executes in 1 second and returning 14 rows whenever I execute it through Management Studio but when I execute it from a web page I am getting a timeout message and the stack trace is pointing towards the line which calls the stored procedure. The query is quite complex and there quite a few joins on tables and views including one to a lookup table, whenever I take out join onto the look up table the web page runs ok without timing out. I join the Lookup table (Parts) using a Left Outer Join similar to below. The syntax of the Join is fine but I cant find why it would cause the query to time out when executed from a webpage but is fine when I execute it from Management Studio
select *
from tables/view LEFT OUTER JOIN
Parts on Parts.PartNumber=tables/View.PartNumber
I've tried recompiling the Parts table but it didnt make any difference.
Any help would be much appreciated.
Cheers,
Frankie
View 3 Replies
View Related
Mar 28, 2001
I use SQL Server to provide data to asp web pages and have recently started to get ODBC time outs throughout the day.
The environment is as follows:
Server with dual PII processors & 512MB RAM running:
- SQL Server 7
- IIS
I have a number of asp based web sites hosted on this box, but only 1 of them seems to be affected by the time out problem. I have checked the resources on the server (NT Task Mgr - Memoey & Processor) and everything seems fine - in fact the resources are hardly being touched!!!
Within a few minutes the problem disappears completely without me doing anything.
Am I missing something here?
Should I look elsewhere other than SQL - maybe IIS ???
Any suggestions / pointers would be very much appreciated.
Thx
View 1 Replies
View Related
May 7, 2001
I have a table that has three fields:
CATEGORIES
----------
catID
description
parentCatID
Some categories have sub-categories. Therefore, some entries will have null
for parentID while others will point to another category.
I need to select all of the categories, but have them returned in the
correct parent/child order (parents BEFORE children). I can't seem to get this to work correctly. Is this not possible or am I just being stupid?? :)
Thanks for any assistance.
Mike V.
View 5 Replies
View Related
Aug 21, 2000
We are using asp's and tables sucessfully but when we click a link to an exe on a page it is slow, to the point of timing out. Very slow. Any help would be appreciated. Email me tperry@kpmg.com
Tim
View 2 Replies
View Related
Feb 28, 2001
Does anyone know how to time a DTS package?
Thanks
View 1 Replies
View Related
Jun 23, 2004
What could be the reason for my view to timeout? I thought it was because of the number or records, but i guessed wrong. The view is grabbing data from a UDF i have created.
View 1 Replies
View Related
Sep 10, 2004
Just a simple one I think?!!!!!
Is there any way of copying a DTS from one server to another?
I just need to play with this DTS on our test server but can't copy the thing!!!
Thanx!!!!
View 2 Replies
View Related
Oct 25, 2004
is there a way to format data on the tables. Such as Social security numbers 00/00/0000 or formating of dates 99/99/0000;0;_
is there a way of doing that on a sql table maybe??
View 3 Replies
View Related
Jan 3, 2008
I am trying to use statistics to get the time it takes to run a sql function. When I use SET STATISTICS TIME ON it returns multiple results (one for each insert statement in my loop). Is there any way to get results for the ENTIRE function? Here is the loop that I am timing.--> (It simply populates a calendar table)
SET NOCOUNT ON
DECLARE @Counter INT
DECLARE @ActualDateDATETIME
DECLARE @FirstDateDATETIME
SET @Counter = 1
SET @FirstDate = '1/1/1900'
SET @ActualDate = @FirstDate
WHILE @Counter < 43830
BEGIN
INSERT INTO Calendar(ActualDate)
values(@ActualDate)
SET @ActualDate = DATEADD(day, @Counter, @FirstDate)
SET @Counter = @Counter + 1
END
View 14 Replies
View Related
Feb 18, 2004
Can anyone tell me as to how I can Timeout a transaction. For example I have transactiopn that pulls in data from a remote source. So if the time of extraction exceeds sometime say 1hr..I need to rollback the transaction.
Cannot use Set Lock_Time out because it can be used only for timing out a waiting process. Here I want to timeout the executing process
Regards
Manmeet
View 1 Replies
View Related
May 12, 2004
What is the "Microsoft SQL Server 2000 Resource Kit"
I was persuming it was a programme or patch for SQL server, however it's lookign more and more like a book.
Could some please clarify and if it is a programme/patch how can I get hold of it?
View 5 Replies
View Related
Apr 13, 2008
I have two tables:
1) Table that holds all available ports.
2) Table that holds users for each port.
There may be times where one user is getting more than one port at a time.
I've built up an ASP .NET page that will display each user its port/s in one table.
On another table I want to display all the other available ports which the user doesn't posses and can buy to own.
My problem is where I try to build up the query. I just can't get all the other ports in normal display.
For example, this is what I need:
Ports table:
1/1
1/2
1/3
1/4
Users table:
User A , 1/1
User A , 1/2
ASP page display:
------------
User A Holds:
1/1
1/2
------------
Available:
1/3
1/4
------------
Of course the Available option is derived from the User Holds query, and just getting the opposit not equal ports, but I just can't get it !
I've tried all kinds of Joins and nesting SELECT queries with no luck.
I hate SQL. I want to die.
View 4 Replies
View Related
Nov 24, 2005
Afternoon everybody...
Here is my noob question of the day, is there a query I can run to display the STRUCTURE of a table? fieldnames, datatypes, sizes etc?
Select * from users where clue > 0
View 4 Replies
View Related
Feb 12, 2008
How can I easily time a query entered in Studio Express for SQL Server 2005? Thanks in advance.
View 11 Replies
View Related
Mar 27, 2008
Hi. I'm new to SQL Server programming. I'm using it at my new job for the first time and catching on quickly. I've run into a problem where I run a request via interactive query and it times out. It's really annoying because it seems to happy a lot. Is this just a memory issue with my machine (it has 2.8 GB of RAM) or there a way around it?
Thanks!
View 12 Replies
View Related
Jul 20, 2005
Hi all,i have 97 honda CR-V with about 100,000 KM on it. i checked a doc onHonda web site and it said that 60,000 miles is point to change timingbelt. compared with other Honda cars, it is pretty low. is it correct? ifyes, do you know the reason??thanks for your help,jj
View 2 Replies
View Related
Apr 5, 2006
here is my problem.
i have a table that looks like this
barcode |movetype | qty
as3 | T | 4
as3 | R | 2
as3 | T | 1
here is my problem and i am probably just stupid. i need the total amount Transfered minus the Received per barcode. so here i would need to see a total of 3.
i don't know how to do this.
View 4 Replies
View Related
Nov 10, 2006
I'm using SQL 2k.
I wrote a query using the query analizer and tested it before turning it into a Stored Procedure. It worked fine an the execution time was acceptable (25 secs, since there was a lot of data to analize)
When I executed the recently created stored procedure, the execution time happened to be three or four times higher. (1 min, 38 secs)
It was the exact same code, i was logged in the same database server, the parameters were the same in btoh cases. So, my question is as follows:
Why is it that executing a script and executing a stored procedure with the exact same script differ so much in timing?
View 1 Replies
View Related
Aug 23, 2007
I've getting the error message at the time ntbackup starts the backup of the server:
Event Type: Error
Event Source: SQLWRITER
Event Category: None
Event ID: 24579
Date: 22-Aug-07
Time: 20:00:26
User: N/A
Computer: DBS
Description:
Sqllib error: Database DYNAMICS of SQL server instance XXX is stored on multiple volumes, only some of which are being shadowed.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 53 51 4c 53 4e 41 50 43 SQLSNAPC
0008: 33 36 31 00 00 00 00 00 361.....
0010: 53 51 4c 53 4e 41 50 43 SQLSNAPC
0018: 32 34 36 00 00 00 00 00 246.....
Where is the problem?
How to fix this?
Does this mean that I would not be able to restore server in the case of failure?
SQL - version SQL Server 9.0.3054 (2005 SP2)
OS - 5.2.3790 (W2k3 R2 SP2)
MS Dynamics GP 9 is installed on this platform.
Any ideas?
Thanks in advance.
View 7 Replies
View Related
Mar 7, 2007
I am trying to insert form data...three form sections into three different tables....i can insert into one table just fine....is this not possible ...or what? If so can someone please send me a small sample... thank you ...by the way i am using visual studio...vb asp.net 2.0 with ajax. Thanks in advance!
View 6 Replies
View Related
Oct 31, 2007
I am creating an index on a table wit 35 million records but I get the error
'TT_ObjPerformance' table- Unable to create index 'IX_TT_ObjPerformance_CACode'. Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
How can I get the index created?
ThanksSQL Server newbie
View 1 Replies
View Related
Jan 3, 2006
I haven't tested it, because at the moment I can't access my SQL database
I know this is probably a stupid question, but...How can I test for DBNull when I'm using SqlDataReader.Item(string)?
I use to check it using: if(!reader.IsDBNull(2)) ...But I have found that can not count on a particular ordinal reference because some of the stored procedures select the columns in different orders.
can I do something like: if(reader["Column1"] != DBNull.Value)or with the reader["Column1"] throw an error because it is not found??
I too hate when people ask questions that they could test themselves...but I can't really test it at the moment. Any input would be greatly appreciated.
View 2 Replies
View Related
Dec 18, 2001
Hi Guys,
Anyone knows if there is a SQL equivalent of Oracle SET TIMING ON to give the excution time in milli/centi Seconds?
Cheers,
xiaobing
View 1 Replies
View Related
Jun 8, 2000
I'm trying to backup a database onto a different server
within the same SQL Server Group, but the Enterprise
Manager only offers the drives on the local server as
destination options. Do I have something configured
incorrectly or is there a way to do this manually?
Thanks in advance.
Doug
View 2 Replies
View Related
Mar 10, 2001
Ok, I'm trying to understand how the db user corelates to the SqL login. Can one db user have multiple logins attached to it (like dbo with sa and nt admins).
This is in reference to the issue of broken chains of ownership problems that pop up from multiple users creating tables in a single database. I would like to be able to make all the developers be the dbo user of a given database without making them a sysadmin of the entire server. Is this possible?
If not, is there a sp that fixes a db so that all ownership reverts to dbo?
Thanks in advance
fUngUs
View 2 Replies
View Related
Jan 24, 2001
I am trying to run a program that works on another site but with a copy of the database(SQL6.5) and the vb front end I keep getting a timeout error.
The vb bit is trying to run an update statement on a table with just over 2000 rows. I cannot amend the vb side because this is an .exe
Is there something I might not have done on the server that could be causing this not to work, i.e configuration issues, bigger logs
Please help!!
View 2 Replies
View Related
Oct 27, 2003
What does "WHERE 1=1" do?
View 2 Replies
View Related
Mar 29, 2006
I have a little query in access ..now i must write it in T-Sql
the original...
(MSG.IDLINGUA = IIF( EXISTS
(SELECT * FROM ESMESSAGGI AS MSG WHERE MSG.IDLINGUA = [@idLingua] AND MSG.IDMESSAGGIO = BITS.IDDESCR),
[@idLingua], LDEF.IDLINGUA))
I can't be able to assign a select value at my field... IDLINGUA to perform another select..
Of course I have used the "select case when exists"
Anyone could be help me ?
View 2 Replies
View Related
Sep 7, 2007
Hi
I want to run SQL Server 2000 at home, on my PC. I dont have a server. My OS is Windows XP. Is this possible? Or do I have to use something like Access. If so then that sucks.
I use SQL Server at work and I want to practice at home.
please help
p.s i have Personal ed and standard ed.
thanks
Paul
View 9 Replies
View Related
