Create table problem

I have been trying to create a table since morning but it save as a system
table instead of a user table. anybody has any idea? I tried to create both
GUI(Enterprise) and Analyser prompt but all the the time system made a
system table instead of a user
thanksFarrukh wrote:
> I have been trying to create a table since morning but it save as a system
> table instead of a user table. anybody has any idea? I tried to create bot
h
> GUI(Enterprise) and Analyser prompt but all the the time system made a
> system table instead of a user
> thanks
It looks like somone has executed the sp_MS_upd_sysobj_category
procedure with a parameter value of 1. Execute it with the value 2
as parameter and verify that objects now created will not be
system objects.
I strongly recommend that you search the net and read up on this
procedure before executing it. It is an undocumented proc and should be
avoided.

Create table problem

I have been trying to create a table since morning but it save as a system
table instead of a user table. anybody has any idea? I tried to create both
GUI(Enterprise) and Analyser prompt but all the the time system made a
system table instead of a user
thanksFarrukh wrote:
> I have been trying to create a table since morning but it save as a system
> table instead of a user table. anybody has any idea? I tried to create both
> GUI(Enterprise) and Analyser prompt but all the the time system made a
> system table instead of a user
> thanks
It looks like somone has executed the sp_MS_upd_sysobj_category
procedure with a parameter value of 1. Execute it with the value 2
as parameter and verify that objects now created will not be
system objects.
I strongly recommend that you search the net and read up on this
procedure before executing it. It is an undocumented proc and should be
avoided.

Create File

Hi
Is it possible to create file on server side with sql server 2005.
lets say
I have table and PDF files stored in this table (binary)
No i want to save this file on server side to specific folder?
Best regards
Mex
Sure as long as the SQL Server service account has the permission to do so.
Simplest example is EXEC xp_cmdshell 'dir > c:\temp\junk.txt'
Linchi
"Mex" wrote:

> Hi
> Is it possible to create file on server side with sql server 2005.
> lets say
> I have table and PDF files stored in this table (binary)
> No i want to save this file on server side to specific folder?
>
> Best regards
> Mex
>
>
|||On Jun 15, 8:32 am, "Mex" <redivi...@.hot.ee> wrote:
> Hi
> Is it possible to create file on server side with sql server 2005.
> lets say
> I have table and PDF files stored in this table (binary)
> No i want to save this file on server side to specific folder?
> Best regards
> Mex
Sounds like a good place to use a CLR stored procedure if your app/
middle tier won't provide this.

Create File

Hi
Is it possible to create file on server side with sql server 2005.
lets say
I have table and PDF files stored in this table (binary)
No i want to save this file on server side to specific folder?
Best regards
MexSure as long as the SQL Server service account has the permission to do so.
Simplest example is EXEC xp_cmdshell 'dir > c:\temp\junk.txt'
Linchi
"Mex" wrote:

> Hi
> Is it possible to create file on server side with sql server 2005.
> lets say
> I have table and PDF files stored in this table (binary)
> No i want to save this file on server side to specific folder?
>
> Best regards
> Mex
>
>|||On Jun 15, 8:32 am, "Mex" <redivi...@.hot.ee> wrote:
> Hi
> Is it possible to create file on server side with sql server 2005.
> lets say
> I have table and PDF files stored in this table (binary)
> No i want to save this file on server side to specific folder?
> Best regards
> Mex
Sounds like a good place to use a CLR stored procedure if your app/
middle tier won't provide this.