and noting that DEFAULT(0) is just shorthand for creating a constraint might make this more obvious, as well:

ALTER TABLE SomeTable

Add MyColumn int --data type

null --null or not null

default(0)...

bcp is a command line/console application,and...

pooya1072 (5/28/2013)

---

hi friends

i want to add a column to a table with conditions below :

1- it has a default value=0

2- this column can get null value

3- no constraint should be...

it kind of sounds like you need a calendar table;

that way, you could select every possible date from the calendar table, and then left join it to the data you...

here's two examples of what Kingston was referring to;

I personally prefer to use the sql server specific metadata, rather than the information_schema, but it's effectively the same thing:

the only reason...

assuming the second table could potentially be the same size as the max for the first, it looks like a 30 gig database to me for just the data?

1.5Meg *...

it sounds like orphaned users to me, is that right?

for SQL users(not windows users)

if you restore a database from a different server, the user "Bob" on my server is...

that's usually handled by either the client application,...

you can only create a SQL user without login;

so CREATE USER [ClarkKent] WITHOUT LOGIN is fine and will work;

but if you put in a slash in the name, a windows...

i've used filezilla from a command line, as well as CoreFTP; both of which support SFTP and other protocols;

i think FileZilla is free, and I know we paid for CoreFTP.

https://wiki.filezilla-project.org/Command-line_arguments_(Client)?

can you edit the SQL Server(SQLEXPRESS) service, and change the startup account?

Change it form whatever is there, to your username and password, for example, and then start the service?

I have a certain fondness for doing solutions in TSQL, or at least be centered around TSQL, regardless of whether it's the right tool for the job or not.

I...

killing a linked server action that is using a distributed transaction pretty much guarantees a reboot is required to complete the rollback.

it depends on what the query is actually doing...

first, lets make sure you know the name of the instance, and the instance is actually running.

It's quite possible you installed the Tools but not the service itself, or the...

pretty sure RAISERROR requires three parameters, and you only passed one.

RAISERROR ('Duplicate Records',16,1)