Forum Replies Created
Viewing 15 posts - 3,586 through 3,600 (of 13,460 total)
-
RE: Access Control of SQL Login
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: cmd line rename syntax error - argh
well as John Mitchell pointed out the ren command syntax found here does not allow the path of the filename as part of the second parameter.
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: Error 5 when trying to connect to database
austen.robinson (4/24/2013)
So let me understand. Where do I install my SQL Server during the installation? Or is it a problem with the VS project? Confused.Ok your problem...
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: Error 5 when trying to connect to database
easiest fix is to move it out of your personal folders:
c:\users\austens samsung
a fresh installation of SQL has permissions to it's own folders under program files, and it's own folders under...
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: Virtual CPU limit for SS2008 Standard edition
when you say "CPU's, are you referring to virtual CPU's? i believe Standard 2008 is 4 sockets, but the Virtual CPU's could be, say 16 on a four socket...
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 copy a table structure and data to a different server?
there is a very handy free plug in for SSMS here:
one of the options is to right click on a table in Object Explorer>>SSMS Tools>>Generate Insert Statements
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: Convertir texto a fecha en sql server
Lynn, do you know why my calculation is off by two days? is it because SQL's zero date on 01/01/1900, but Excel thinks zero date is 12/30/1899 ?
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: Convertir texto a fecha en sql server
rcherod (4/24/2013)
Estimados, 🙂I would like to inquire about how to convert a date format of strange, I have a txt file that comes with the date field as follows:
Name fecha_asist
Pedro...
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: Database Mail
Damian-167372 (4/24/2013)
may be you can try some telnet commands to send an email first and see if there is any ports are blocked to access the smtp server from your...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: Using SET IDENTITY_INSERT with trigger
ok, i'll skip the peer review and go straight to the error you are tripping over:
your error was pure syntax.
the SET IDENTITY_INSERT must be inside the body of the trigger,........
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: Using SET IDENTITY_INSERT with trigger
wow that looks a little scary to me, where maybe the logic isn't quite clear.
it looks like you want to delete any existing records that might end up having...
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: send me dowload link for SSIS
aaron.reese (4/24/2013)
Which is sort of annoying!It means that home developers and/or people trying to 'break in' to SQL development have a huge barrier to entry. I understand why Microsoft...
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 to prevent dropping of a specific table?
well, note the comments in the thread;
if you need to protect 400 tables, it's probably better to look at the security aspect of it, adn not tackle this via a...
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 to prevent dropping of a specific table?
Andy did you copy the trigger verbatim or modify it a bit?
it worked fine for me when i posted to the thread originally;
can we see your version of...
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: NO. of instances
ok by looking at a different registry key and looking for Service names, i think this finds them all on my sample machine:
/*
ResultsId ResultsText
233 ...
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 - 3,586 through 3,600 (of 13,460 total)