Forum Replies Created
Viewing 15 posts - 7,516 through 7,530 (of 13,460 total)
-
RE: any script for getting server login role permissions in sql 2005
lots and lots of script contributions here on the site:
http://www.sqlservercentral.com/search/?q=script+roles
also search fro "script permissions", lots of nice examples of that as well.
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 manage databases without sysadmin role?
the OP asked in a PM how I had done my stored proc i referenced; I'm posting it here to add fuel to the fire; others might have some ideas...
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 manage databases without sysadmin role?
I've created a stored procedure featuring EXECUTE AS that allows an end user to Create a Database, which then adds roles to that database, and finally adds the calling user...
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: trace?
opc.three (5/25/2011)
Just eyeballing your code so forgive me if this is a rabbit hole but I think if client_net_address is NULL then you end up with something that will anger...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: simplied the sp
huh?
maybe a copy/paste error?
EVERY statement you posted is making the Question1 field equal to a count of the persons name?
it looks like the sub query gets a total, and has...
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: trace?
ok, following up here, i created a server trigger, and a user with the same name as the OP for testing.
I'm gathering info based on this snippet to get 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: Importing very large flat file throws truncation errors
the columns in the table and the columns in the BULK insert must match exactly, with no extra or missing columns....unless you use a format file.
you can use OPENROWSET to...
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: Importing very large flat file throws truncation errors
Jeff Moden (5/24/2011)
Gosh, folks. I've not tried to import the data (yet) but the "Read Me" pointed out in the original posts seems to identify column requirements quite nicely....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: Importing very large flat file throws truncation errors
what a pain that file is.
this is what i did:
i converted all teh damn unix LF to vbCrLf.
then i used this script...i had to tweak it a few times,...
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: Format statement
indenting code is your best friend.
while there's no hard and fast rules, i tend to do something like this:
columns indented compared to the select
joins are indented from the 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: Watching connections...
could it be users from the domain that are not explicitly added as logins? so if the domain group myDomain\Dev was added, people get in with no login?
so you'd have...
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: Importing very large flat file throws truncation errors
pretty sure it has to do with the import package defaulting to a 50 char field, and the data for example, on line 1284 is 54 characters in length.
"Beautiful Zion...
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: Backup script with specific needs
not sure it's possible...you need the backup to complete before you can determine it's size....
That makes me think it cannot be done before the backup is complete...unless it's based on...
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: Script all indexes as CREATE INDEX statements
patelekta (5/24/2011)
May be you will get your answer on http://ektaraval.blogspot.com/2010/07/query-to-generate-create-index.htmlekta your example only works if an index has one and only one column in it's definition...otherwise it scripts two definitions...
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: BarCode Creation
also note there are different types of bar codes, so you need to know which style you need:
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 - 7,516 through 7,530 (of 13,460 total)