Forum Replies Created
Viewing 15 posts - 11,641 through 11,655 (of 13,459 total)
-
RE: adding .PRC with color coding in SSMS
yep you can fix this:
Tools>>Options>Text Editor>>File Extension
type PRC, choose Query Editor and hit Add; next time you load that file extension, it will use the syntax highlighting engine:
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: Primary Key Values
if you need to fix the LineItem table prior to archiving it, you might want to do something like
UPDATE LineItem SET LineItemID = LineItemID + 240000000
that, by...
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: searching for linked server references
this is just a prototype for a single database, but it's easily adaptable i think.
I'm assuming that the current server has all the linked servers....so I thought why not search...
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: slow performance
specific procedure is slow...but runs fast if you run the statement in SSMS?
sounds like parameter sniffing to me.
when the code is compiled into a procedure, the compiler makes a best...
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: defrag tool on MDF and LDF files?
fragmented MDF files happen in situations where the file gets shrunk, or needs to autogrows to hold more data.
ideally, you pick an initial size of a database so that the...
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: DDL Trigger for DROP Objects
this updated code that i posted previously does not raise any errors. it cannot get teh definition on drop procedure, but it does get creation and changes.
[font="Courier New"]
CREATE TABLE [dbo].[DDLEventLog](
[EventDate]...
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: How can i remove the history of server name selection in login window
I looked in the registry on my machine, and I think this is where you want to go to delete old servers you no longer connect to:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\SuperSocketNetLib\LastConnect
mine has a list...
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: Read-only access to all domain users
the problem is, some domain users may come in with more rights than you want to give them....a domain user might also be a domain admin, so giving a group...
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 Query
because this question looks a lot like what a homework assignment would require so that you get used to querying and displaying data, you'll need to show us what you...
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 Query
look at the sysobjects table.
there is a column there called "xtype". you could count(*) from sysobjects where xtype='U' for example, to get all user tables. V for views, you can...
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: Group By Clause
SQL Server, or any relational database system for that matter, doesn't put data in any specific order unless you tell it to.
the primary key of a table is used...
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: DDL Trigger for DROP Objects
From BOL:
DDL triggers fire only after the DDL statements that trigger them are run. DDL triggers cannot be used as INSTEAD OF triggers.
So I think if you simply do CREATE...
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: DDL Trigger for DROP Objects
I took one of the examples I'd gotten here and modified it to get teh sp_helptext of the procedure being affected.
my audit trigger is called AFTER the CREATE/ALTER DROP event...so...
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: Triggers to Protect tracing data?
triggers have their purpose...i think the bad rap triggers get come from people trying to do stuff that should never occur in side a trigger anyway.
I've seen requests on opening...
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: How can i remove the history of server name selection in login window
the info is stored in the registry.
open regedit and search for one of the servers you know you want to eliminate. you can see which ones exist from there.
on my...
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 - 11,641 through 11,655 (of 13,459 total)