SanDroid (9/14/2011)

---

Toreador (9/14/2011)

---

Good idea.

But how many points...

SanDroid (9/14/2011)

---

SKYBVI (9/14/2011)

---

SanDroid (9/14/2011)

---

First insert fails becuase of...

Sudhir Dwivedi (9/14/2011)

---

Hmmm... You can try these lines to see the difference:

select CONVERT(char, 'This is a SQL Server Central Forum')

select CONVERT(char(1), 'This is a SQL Server Central Forum')

select CONVERT(char(100), 'This...

SanDroid (9/14/2011)

---

First insert fails becuase of the...

hI,

I cant know why, the first and second insert statemtns wont get inserted, the PK is not violated...

So hte 1st select statemtn should give 2

...

I guess...nothing should happen... it should take in effect after you try to change password of the login...

Dont you have any dev environment, where you can change and check ?

Regards,

Sushant

is that a question or an answer?

what does your log files say located on server:-

default location:-

C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\LOG

Regards,

Sushant

yes, I also experienced something like that...

Btw...whats's ur version of sql server

Generally, if i have some simple t sql statements, i would prefer to run them through sql agent jobs...

Hi,

I changed the data types successfully..

I used

SELECT CAST(mycolname AS float) FROM tablename

SELECT CONVERT(FLOAT, mycolname) FROM tablename

After running above statments,

I still got same error "it cannot...

I think PLU_NUM(float) its float values in sql 2000..

Doesn't CAST convert only 1 value not all the values in a table?

Regards,

Sushant

when i execute that query on my server, it says

User doesn't have permission to run htt query

Why does it tell so when i already logged in as sa??

aNY SOLUTION?

GilaMonster (7/21/2011)

---

Let's consider this situation.

Sunday 10pm full backup

Log backups every hour

Monday 10pm full backup

Log backups every hour

Database fails spectacularly at 3pm on Tuesday.

I go to restore the Monday night backup....

Is it Replication??