Microsoft SQL Server Forum

Msg 262, Level 14, State 1, Line 1 CREATE DATABASE permission denied in database 'master'.

I am working in access project, so the backend of the system is SQL, I tried to build a query to retrieve the data based on the date, the date appear in different form in a text box, so when I put the date in the text box and run the query I need the query to give me the data based on the date in the Text box. I tried to put in the query as...

Hey people, i am getting this error 'Incorrect syntax near the keyword 'EXISTS'.' while executing this query SELECT Contract_detail.Contract_no FROM Contract_detail INNER JOIN ContractRewriteHistory ON Contract_detail.Contract_no = ContractRewriteHistory.ContractNo WHERE Contract_detail.Contract_no NOT EXISTS ( SELECT...

i have a 'Like' condition in Sql Server Select query My condition is this: WHERE IntestazioneCompleta LIKE '%D'AZEGLIO%' if i have a simple word like 'AZEGLIO' all works fine but with this type of word 'D'AZEGLIO' how i can format this in sql to make it work with this type of words? thanks in advance..

Hi SQL Gurus, I have a question on how to load text data in a MS word file. Here is the sample data: -------------------------------- John is my friend. He is at 19. Smith asked me how old is John. I told him John is 19. Smith said John looks like 30. ---------------------------------

I have many columns of data. They are all using the money datatype. When I enter a value into a column such as 32.00, it only shows up as 32. When outputted to an ASP page using a query it also only displays 32. If the data is 32.33, then the display is 32.33. How do I get it to display 32.00? Thanks!

how to concat two strings in stored procedure using sql server???

Can someone help me to figure out a query for this requirement? I have a table with the follwoign columns: ID Agency Value 1 A 1000 1 B 2000 1 C 3000 2 A 1100 2 C 3100 3 B 2200 3 C 3200

All, When I try to load data into a table using a csv file I get below errors. bulk insert client_key from 'T:\CLIENT_KEY.txt' WITH ( FIELDTERMINATOR =',', ROWTERMINATOR = '\r\n', DATAFILETYPE = 'widenative')

Good Evening, The following is a subset of a table I have in an MS SQL 2008 DB. I am trying to output to a table, the Serial Number , the LID with the greatest count of consecutive LID values, and the actual count. Important to note that the table is ordered by the Last Updated Date value descending (this condition is critical). It can be...

Hello, I have a database of 100million rows and need to do a like statement with "%test%". I understand that it does not use an index and it is really slow and resource intensive. Is there a way to use a Full Text search to get the middle of words? I know you can use word beginnings like '"test*"' but what about '"*test*"' and return the...

A few questions: Is there a way to use a query multiple times? I know you can use a CTE but that will be removed after the next query and I do not want to create temp tables on a highly used database. Is there a best practice for doing searches? For example, if someone searches "SQL" on 10mil rows, I want to return both the paged results...

Hello, I have database that is using high tempdb usage in MSSQL 2008. I found the query that is causing the issue and tried to streamline the query but it still has queries going into the tempdb and uses 100% of HDD which creates lag. The database has high usuage and is around 10million rows. I have tried to create multiple tempdb files...

I have an Database Table containing columns, 2 columns of my problem concern are: - column Date - column Time I'm using that Table to show data by DateTime On my form I have: - 4 dateTimePickers(2 of them for Date, 2 of them for Time) - dataGridView - button

I've hit a wall and would appreciate any pointers in moving forward on some code... I have some data in the following format: ID, QtyIN, QtyOUT 1, 30, 0 13, 0, 40 16, 50, 0 32, 0, 40

I want to write a check constraint in SQL Server to check that the ID is exactly 5 characters long, starts and ends with an UPPER case an there are 3 digit in between. Do I use a LIKE clause? Or how? I tried using CONSTRAINT ValidID CHECK (clientID LIKE '') But if I do this, and I insert a id 'a123e' (starting and ending with small...

I have a table1 id col1 col2 1 NC_001A>T 5 2 NC_001C>G 4 3 NC_001G>C 3 4 NC_001_98_G>C 1 Now, I want to have max col2 value for partially duplicate col1 value

Hi..., My self Venu.., I have written program for retrieving data in sql server 2008 but not getting required results. And My Requirement is getting readings from table1,table2,table3 where latest reading stored in data base which is in table3.the data stored in table 3 in the from of date and time mode in date and time column.so i want...

I am using SQL Server and want to extract the month name (e.g. January, February, March etc) from a date. I am going to be plotting the data in a chart and need the data in month order not alphabetical order. It doesn't look like the datepart() function will do this. Can the SQL date function be used in SQL Server? I'm trying to avoid having the...

hey hi i have table like this a b c 1 4 7 2 5 8 3 6 9 i need that all data under a,b,c in once column of another name like this d 1 2

Hi, I have a vb.net windows service to rename a file placed in some folder of a windows server 2008. I want this service to rename the file as different a user as it does not allow for the nomal user. Since the windows service runs in different context as local user which allows to rename the file, i am starting the service from a stored...

I have two Windows Server 2003 servers and each uses SQL Server Reporting services. What's happening is the event viewer shows the service didn't respond in a timely fashion. However, I can start the services manually and all is right with the world. These services are set to Automatic startup in services. I believe they are using the default of...

I have sql express which was installed when i was installing VS 2008.. now i want to install SSRS, i know sql 2008 can have SSRS but i can't install SQL 2008,, is it possible SSRS can be installed with having compatiility with sql 2005,?& from where i can download the package?

I have some developers who want to create .xlsx files from SQL Server. There is a claim that it necessary for me to install excel on the server in order for this to work. Is this standard practice? They are running an SSIS package to create the files. I think there is a c# solution that you can add with a script task to avoid...

this is my prcoedure... ALTER PROCEDURE test @fromdate as varchar(50), @todate as varchar(50), @mailbox as varchar(25), @open as int output, @close as int output, @queue as int output