Forum Replies Created
Viewing 15 posts - 8,971 through 8,985 (of 13,460 total)
-
RE: Changing Colour of QA to differentiate between Prod and Test
WayneS (8/5/2010)
If it's a registered server, right-click server and select properties. Go to the connection properties tab. Check the "Use Custom Color" checkbox, and select the color.If it's a server...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: DATEDIFF function resulted in an overflow on one instance not the other
the error is related to the actual data being tested/datediffed. one instance has data that is out of range.
when you use datediff with seconds, there can only be something like...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: Sql Server 2005 Sorting when having both english letter 'e' and french letter 'é'
basically you have to determine that if any high ascii character(>127) exists, you want to use DESC sort order on the example i provided, but if no high ascii exists,...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: User losing permissions
things to look for:
1. the user would lose his permissions every time the database is restored to a version that did not have his permissions previously.
2. if this is object...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: adding mb, kb and gb to database file report
glad i could help; there's a lot to do in there to make it report-presentable..convert to decimal a couple of times along with the division and case statement;
much easier...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: adding mb, kb and gb to database file report
this should help you visualize; you'll need a case statement:
/*--results
KB MB GB...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: Sql Server 2005 Sorting when having both english letter 'e' and french letter 'é'
this seems to do what you want...i'm doing an order by on the username, and then the username with case sensitive collation:
the desision to order by the second as DESC...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: need some help with row_number()
here's the visual results of my current query for reference: my expectation is that for AREAID 1887, the "buidlingindex" should be all "1", and the apartmentindex increments as seen below.
ID...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: Snapshotting our database causing application timeouts!
not an expert here by any means, but i think "NetAPP SnapManager ", and what it is doing behind the scenes is more than jsut a SQL Server Enterpise Snapshot;...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: Copy Existing Table Structure To Existing Table
go to the scripting options and check "script indexes" "script "triggers" and anything else you might need scripted,a nds simply rerun the process.
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: Copy Existing Table Structure To Existing Table
in SQL Server Management Studio, have you tried right clicking on the table and selecting "Script Table As ..."
Then you can rename the table and the constraints that are part...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: Windows Login Disabled
windows login methods are never disabled...but a domain login might not work yet, is that what you mean?
can you right click on the link to SSMS and choose Run As......
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: audit the hosts on a server
in that case, look at this article, which shows how to audit access to the databases with a server side trace:
http://www.sqlservercentral.com/articles/Administration/trace/872/
once that is in place, you can insert the results...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: audit the hosts on a server
rather than tracking where the inapproprate acces sis coming from, you could change the passwords for those two users, or maybe use a logon trigger to prevent access for those...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: Encrypted Views
i believe when you google as instructed above,you'll finds posts referencing how when you connect via the Dedicated Admin Connection(DAC), everything is decrypted for you, so you could script...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!
Viewing 15 posts - 8,971 through 8,985 (of 13,460 total)