Forum Replies Created
Viewing 15 posts - 11,596 through 11,610 (of 13,460 total)
-
RE: Preserve EM registered server and SQL server group
ok i think the per user settings are here:
HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\80\Tools\Client\PrefServers
for a user that is not logged in, i found a different set of servers here:
HKEY_USERS\S-1-5-21-515967899-1220945662-839522115-500\Software\Microsoft\Microsoft SQL Server\80\Tools\Client\PrefServers
his specific SID...
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: View and SQL2000 performance
and building on happycat's list:
how are applications getting data from the views? if the application is doing SELECT * from 100GigView with no WHERE statement, and then filtering the recordset...
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: Preserve EM registered server and SQL server group
Lester on my machine, my 8.0 list of names are in the following key in the registry:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\SuperSocketNetLib\LastConnect
i don't know where the passwords are, but you could at least keep ...
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: Filling NULL values
forum software ...add a closing parenthesis right before the q...
) q
it took amersand-nbsp-semicolon)
and turned it into this:
😉
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: Filling NULL values
nice noel; adding that to my snippet collection.
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: Calling Stored procedure at specific time
bad news: I agree with your client. there is no reason to to try and update a column every 30 seconds or one minute or on a specific schedule,...
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: Filling NULL values
im assuming your ID column is an identity...using the code below, if you repeat the update several times until no rows are affected, this will work:
[font="Courier New"]
CREATE TABLE EXAMPLE(
ID INT IDENTITY(1,1)...
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: Stored Procedure SQL
if you sp_helptext procedurename, it returns the text of the procedure, including all its comments, in the same format as wehn last created/altered.
if you do this in gridmode in SSMS,...
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: Reading from a document without using OPENROWSET
if openrowset is disabled, then most likely xp_cmdshell and sp_OACreate are disabled as well, which were your other options...
I think in this case, the solution is to NOT do it...
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: Retrieve column headers for INFORMATION_SCHEMA
well, the web page itself would run the query, and stick the results in either an ADODB.Recordset, or a .NET DataTable or DataReader, right?
both of those have access to teh...
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 to avoid Table scan from temp db
the same as any other table...after you create it, you'd need to create an index on the table, even if it is in tempdb. that's the only way to improve...
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: Techniques for passing extra information into procedures and triggers
I think what you are talking about is CONTEXT_INFO;
you can store some information in there, and it is specific to the connection; typical examples might be the username from...
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 sql server understands from which point the differential backup should be taken??????
Say you have a big database, and you know from experience it takes 4 minutes to do a complete backup.
the last thing the backup would include would be every commited...
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: List all the tables from all the databases without cursor
Vic is correct. because there is no single repository for the tables/objects of all databases, you have to query each repository seperately...whether information_schema, sysobjects or sys.objects, you gotta do each...
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: Retrieve column headers for INFORMATION_SCHEMA
Ok i think i know what you want;
in SSMS go to tools options.
check the shown checkbox, and when you copy/paste any results, the column names will be included:
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,596 through 11,610 (of 13,460 total)