well it depends.

if load = put the binary of the zip file into an IMAGE/varbinary(max) column, then that's possible.

if load dmeans open the zip/get the(one or more files!) from the...

Krasavita (6/9/2010)

---

I just re created table and I am ok,bit can't add data, what I need to do in order to insert data,should I disable a key and then re...

well, tempdb is a copy of the model db every time the server is started, so changing the model db would change the temp db after a start and stop.

ALTER...

here you go Matt: this is using a function which strips the string down and removes unwanted chars;

take a look at the logic, and see if you understand how it...

In that case, look...

if you use an enhanced text editor like EditPlus,NotePad++,UltraEdit or one of many others, you can do it in a couple of seconds flat:

copy and pasting from grid view of...

so much of what you want depends on specifics...the types of logins,which procs, whether they can read form an tables or not, etc, but this might give you some ideas.

the...

Wayne it's been a while, but i had a similar issue;for me, it was my laptop, which traveled between different networks a lot. i thought it was related to...

Karl in your case, since Tablediff takes username/password parameters for the servers it will compare, you could just include those and not have to fiddle with the startup accounts, but...

Roy it looks to me that this is a rounding issue when the convert is changing to smalldatetime; that is wierd to me as well, since i'd expect the rounding...

a user would need EXECUTE permissions on the functions in order to use them.. read(SELECT) access, like granting db_datareader, is limited to tables or views.

no limit the way you are thinking...you can have one default per column if you want...a table with 200 columns could potentially each have a default value for each of...

xp_cmdShell does not use your credentials.

this is a common security misconception . The problem is that when you access any resource OUTSIDE of SQL server, like network shares, local hard...

sure, it's just like any regular INTO NEWTABLENAME select statement: the column definitions will be derived from the output of the results of the SELECT.

SELECT TOP 3 *

INTO MyNewTable

FROM sys.tables

SELECT...

Paul i think you are on the right track about the collation issue;

your function and examples worked fine; i got the correct proper cas for all the examples you posted.

I...