SQLServerVBA (7/20/2009)

---

The User connects to the production database. There is only one database that the user connects and all tables & stored procedures are on that database ONLY. So there...

could it be security? does the uer who is inserting/updating into the table also have insert rights on the table in the other database?

maybe these specific statements need EXECUTE...

ive seen this before...make sure that user has a specific default database for his login, instead of master. that database should be whatever database he's using for the application.

i think...

there's a script in the scripts ection for sending an SMS in a trigger here:http://www.sqlservercentral.com/scripts/Miscellaneous/31899/%5B/url%5D

that uses the exisitng email-to-SMS functions that every cell carrier seems to support.

there's a lot of...

two ways...you can use the REPLACE function to replace the bad word with an empty string:

UPDATE MYTABLE SET MYCOLUMN = REPLACE(MYCOLUMN,'BADWORD','')

this is a better solution, because if the bad word...

[ edit doh i think i misread your question; i thought this was related to backups over the network, getting xp_cmdshell to work over network, etc...sorry]

I don't think you can...

I agree with Pradeep ; the issue appears that the service is not running.

log into the server, go to control panel/Administrative Tools/Services, and try to start the SQL service again....

Just for fun, I wanted to try this out; I had "Recover4all Professional 2.25", some old undelete program I used to recover some files a while back.

I created a database...

not in the exact same operation, but you can use one backup to restore/create as many databases(each with a new name) that you want.

whether from the GUI, or via...

i believe i saw thread which stated that openquery against a linked server was faster for a linked server vs a query on your server using 4 partnaming conventions;

for example,...

it should work with some minor tweaks:

after you've done the DECLARE @acumul_error varchar(100) or whatever it is, you need to initialize it as an empty string:

SET @acumul_error =''

in the...

here's another option;

you can create a linked server for a Folder on the server, and each text file becomes a table. every file that is comma delimited can...

both are views of course, created to help pull information about the metadata together.

the data in the two columns will often be the same; Information_Schema is a standard format...if you...

wrap any object name with brackets(or double quotes) if it doesn't follow normal naming conventions, has spaces in it, or are the same as a reserved word:

select * from [170703-test]

or

select...

this is most likely the error:

if the table accountinfo has two or more rows, then you'd get the error you describe...maybe you need a WHERE statement to limit the rate...