Dear Friends, There is an ungent opening in MEP a well reputed MNC, Located in Madhapur, requires a IT professional having more that 2 years experience in SQL...
3403
Madhu K Nair
madhuotp
May 1, 2006 11:22 am
Hi, We have migrated our production server to SQL 2005 64 Bit SP 1 . Previously it was on SQL 2000, 32 X and service pack 3a. Now the problem is that, our...
3404
Saurabh Aggarwal
saurabhagg1@...
May 1, 2006 5:42 pm
Hi As you cannot restore higher version (2005) dump on small version(2000) cheers Saurabh Aggarwal(9818208205) ... Saurabh Aggarwal [Non-text portions of this...
3405
Saurabh Aggarwal
saurabhagg1@...
May 1, 2006 5:43 pm
Try this one
sp_helpobject table_name
On Sat, 29 Apr 2006 sunil john wrote :
>can any one tell me what is the syntax for viewing the structure of the...
3406
ciaofromluca
May 1, 2006 5:44 pm
Hi is it ok to run the stored procedure sp_updatestats with users connected to the database? Maybe, during low activity, but anyway with users connected? Any...
3407
virender jain
virender_jain77
May 2, 2006 5:43 am
Just check again, whether hard disk drive letter {D} your specifying are correct or not. There is not any other reason for this, do one thing try to restore...
3408
Madhu K Nair
madhuotp
May 2, 2006 5:44 am
Hi Saurabh, I do not think this is the case. I have restored a test database for R&D purpose with 2 tables in SQL 2000 from SQL 2005. Anyhow, is there any...
3409
radhye
May 2, 2006 5:44 am
The update statics support or help those table which contain so many varchar character. but what is the reson you want t run that? ciaofromluca...
3410
Madhu K Nair
madhuotp
May 2, 2006 9:15 am
Hi Virender , I tried to restore after creating Backup Device from SQL Server Management Studio(2005 Tool). But it also gives me the same error message. ...
3411
sunil john
suniljk7
May 2, 2006 9:15 am
Dear all, Experts please help me in this... i want to combain there two query and get the result.. select CONVERT(varchar,timecreated,111), count(da) from...
3412
Roji. P. Thomas
roji_pt
May 2, 2006 9:16 am
Try sp_help <table_name> OR just press ALT+F1 after selecting the table name. Regards Roji. P. Thomas http://toponewithties.blogspot.com ... From: sunil john ...
3413
Melvin
melvinms
May 2, 2006 9:17 am
Hi Madhu, Try to set the compatible level and see if this works for you. For more details, check sp_dbcmptlevel in BOL -Mel ... ...
3414
Ramesh Karnati
karnati_in
May 2, 2006 12:52 pm
Sunil, Try this Select A.dates, sum(a.counts) From (select CONVERT(varchar,timecreated,111) as dates , count(da) as counts from FarouhaMTMessage FM(nolock) ...
3415
Santhosh
san_spy
May 2, 2006 12:54 pm
Madhu, I dont think it is possible. The only way you can do this is like you can replicate the data or you have to manually export and import the data. There...
3416
dilip kumar
dilipkumar_a...
May 2, 2006 2:40 pm
can u tru this ' declare @sql varchar(1000) set @sql 'select timecreated,aas from (select '+CONVERT(varchar,timecreated,111)+ ' as timecreated, count(da) aas...
3417
Ghanshyam Dayal
ghanshyam.dayal
May 2, 2006 2:42 pm
what is ur profile...means working as what? pallavi b <pallavi_br2005@...> wrote: Hi I am Pallavi, i am new member of this group. thanks regads pallavi ...
3418
Santhosh
san_spy
May 2, 2006 3:19 pm
Is there any t-sql script to script out all the users or logins and their roles and permissions? With Smiles Santhosh S.J. Failure Means Delay Not Defeat ... ...
3419
Roji. P. Thomas
roji_pt
May 3, 2006 7:38 am
Lekshmy, I have passed your second question to some of my colleagues and they come up with a bunch of solutions. Needless to say, All of them are working :) ...
3420
radhye
May 3, 2006 7:54 am
Please right click on the master database .and then choose the script. form the option only choose the role , log in .. it create all the user and login for...
3421
Santhosh
san_spy
May 3, 2006 3:14 pm
Radhey, Thanks for your idea. But I asked for a t-sql With Smiles Santhosh S.J. Failure Means Delay Not Defeat ReadMe @ santhoshpakkangal.blogspot.com ... ...
3422
Akhil Mahajan
dabubcet
May 3, 2006 3:16 pm
Hi all, I have a couple of questions. Firstly, i need to move a database from access 2000 to sql server 2000. I have never done data migration before. If...
3423
md yusuf khan
wetinrain
May 4, 2006 8:18 am
Hi All, Iam on the way of giving microsoft exam 70-229 (Designing and impelementing databases with MS SQL Server 2000 Enterprise). I just passed my exam...
3424
sreenivas
vemuri_sree
May 4, 2006 8:19 am
Hi all I have a small doubt in the database file growth option. I want to develop the project for a big organisation.and i want to mention the file growth...
3425
Madhu K Nair
madhuotp
May 4, 2006 8:19 am
This is a open ended question. This is again how you want to go about it. I have rich experience in Data Migration. I have migrated our organizations39; Legacy...
3426
Madhu K Nair
madhuotp
May 4, 2006 8:19 am
Hi everybody, As Saurabh said, It is clearly mentioned in Book on line and in Microsoft site also that "Backup created by more recent version of SQL can not be...
3427
Anjana
anjana_r21
May 4, 2006 9:01 am
FYI ... From: DeepakRajendran <deepak_rajendran@...> Date: May 3, 2006 9:41 PM Subject: WebChat on ASP.NET Security Model Tomorrow! To: dotNET User...
3428
Veer Ji Wangoo
vwangoo
May 4, 2006 11:06 am
Here is a rough but very simple way to predict data growth
# Step1
Check the size of your table based on it is structure and field size
# Step 2 Check the...
3429
Veer Ji Wangoo
vwangoo
May 4, 2006 11:22 am
Also to test the Dataloading and then performance of Database and application.... check out this tool
http://www.datatect.com/index.htm
-----Original...
3430
Krishna K Uppuluri
sv_39
May 5, 2006 3:06 pm
.mdf got full is there any why to increse or to make some free space for the same with out incresing the size of .mdfeai Team, I have some doubts 1.My .mdf got...
3431
sqlcon@yahoogroups.com
May 5, 2006 3:07 pm
Hello, This email message is a notification to let you know that a file has been uploaded to the Files area of the sqlcon group. File :...